What queries are linked to a particular table?

  • Thread starter Thread starter Joe Man
  • Start date Start date
J

Joe Man

Is there any way to see what queries are linked to a
particular table in a database? I have a database that
conatins hundreds of queries and tables.
Thanks!
 
I use a 3rd party tool, Access Analyzer from FMS: www.fmsinc.com

It will tell you which forms, queries, reports use what tables, queries,
fields.

If your code is set up properly (i.e., you identify all queries as querydefs
and all tables as tabledefs rather than burying tablenames or query names
within string concatenations), it will also cross ref tables and queries
usage within code.

It has a lot of other features as well.
 
Back
Top