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

L

Lyn Crosby

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.
 
K

KARL DEWEY

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.
 
Top