How can I - Printout a Report & Query List

  • Thread starter Thread starter Patrick Graham
  • Start date Start date
P

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.
 
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.
Click to expand...

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