How to find reports/forms that use query (Access 2000 or 2003)

[Guest]

Is there a way, in Access 2000 or 2003, to find out what (if anything) is
using a query that was developed by my predecessor? I cannot find anything
in Help or online that addresses this. I have a query but don't want to
delete (or modify) it if in fact it is used by a report, form, or another
query.

 

[Douglas J Steele]

There are 3rd party products, such as FMS's Total Access Analyzer
http://www.fmsinc.com/products/analyzer/index.html that can help.

 

[Guest]

Use Access ANALYZE - Documentor and select all forms and report. Save to Word
and do a find for the query.

Another way is to just add X- as a prefix to the query and wait for error.

I always save a copy of my different versions and include the date in the
file name.