Report to list all tables/queries used in the database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,
I am trying to create a report that will detail all the available
tables/queries and highlight those that are actually used as part of a
query/form/report.

is this possible? i already know i can query MSysObjects for all the
objects, but i do not know how to write the code that will tell which are
used for data.

thanks in advance!
 
There are tools that can help with this - Find and Replace
(www.rickworld.com) SPEEDFerret (www.moshannon.com) and Total Access
Analyzer (www.fmsinc.com)

Note, though, that no tool can do this with 100% certainty. Complex code
that conditionally assigns the recordsource of a form or report, especially
code that retrieves the name of the table or query to be used from a lookup
table or from the registry, or from an INI file or other external source,
may cause any tool to list as unused an object that is, in fact, used.
 
Back
Top