Is there a way to see what tables are used in all reports?

[gmgrace]

I need to change out some tables and want to find all the reports they are used in. It seems time consuming to go through each report and click on the properties to see what tables it utilizes. Is there any program or function that is built into Access or can be built to view or print this information? Thank you in advance. Gerald Grace
Wannabe Programmer
Please explain steps so I can learn.
Thank You Very Much.

 

[MichaelRed]

Hmmmmmmmmm,

this falls into the category of beyond the beginner ... beyond the intermediate ... and a long reach for the advanced.

It can (sort of) be done by itterating through the document\reports collection and retrieving the "RecordSource" property of each report. Then, the trouble starts. Many (acually for me almost all) of the report sources are not tables, but queries, so then you would need to look up the queries and trace their sources back to actual tables (through however many layers of queriws exist). If you haven't given up yet, there is still MORE (potential) trouble ahead, since any given control on a form or report may use one of the domain functions or even a query string (which would reference one or more tables either directly or indirectly). And the list goes on ( ... and on ... and on ... ).

There are a few third party tools ("Speed Ferrett&quot which claim to be able to freely rename objects throughout the db and also provide reports of the type you describe.

The larger question remains un-addressed. WHY do you have the 'compulsion' to " ... chang out ... " the tables? there are many options in the presentation of the information which hide or 'alais' the actual object names for reporting / presentation purposes without "changing" their internal identies. In the overall sense, these are less likely to cause you grief.

If -afer the above- you are sill compelled to " ... change out ... " objects, please feel free to give my name & contact info tio your (soon to be) FORMER employer, as I REALLY need a job.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over