Check if form and/or query is used

[mjake13]

I inherited a database with 128 forms and 200 queries in the front end. Is there a way, besides going through each one manually, to check and see what queries are and are not used? I'd like to remove the excess junk if they're not needed.

 

[Remou]

Here is one thread, I seem to remember more.

How to identify used Queries in access 2k
thread701-1114258

 

[mjake13]

Thanks Remou.
This helped identify the record sources of all my forms and reports. Now I just need to figure out when and where some of these other queries are being called or used.

 

[MichaelRed]

look into MS Access Queries (a hidden system table)

no good for your forms, but includes (in its own inminitable and arcane way) all you ever wanted to know about the queries.

it WILL take some review and perhaps comparision to other perspectives (view points?) of your queries, but once conquored, you will forever be able to see all there is to know about the queries

what this will not tell you is where the queries might be instantiated from within other Ms. A. objects (e.g. forms, frports, modules ... )

much of that information, however, can generally be gleaned from another one of the mysterious (and hidden( system tables ... MSysObjects.




MichaelRed