How can I - Printout a Report & Query List

[Patrick Graham]

Is there a way to printout a list of Reports and the
queries & sub quiries and sub sub queries that exist in a
database.

I have this database with about 50 queries and 20 reports
and I want an easy way to eliminate the unneeded queries.

 

[John Vinson]

Is there a way to printout a list of Reports and the
queries & sub quiries and sub sub queries that exist in a
database.

I have this database with about 50 queries and 20 reports
and I want an easy way to eliminate the unneeded queries.

Several answers:

Tools... Analyze... Documentor will print out a VOLUMINOUS list of
objects in the database. Set the options so it gives you just the info
you need, or stock up on paper.

Or, get one of the good third-party tools that can check
cross-references to see which queries are in fact now unneeded:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com