What queries are using a certain table

  • Thread starter Thread starter AZEYE
  • Start date Start date
A

AZEYE

Is there a way to find what queries are using a specific
table? I have a database with over 100 queries and I need
to find out which ones are using a specific table. Is
there anyway to do that besides going through each query?
 
Is there a way to find what queries are using a specific
table? I have a database with over 100 queries and I need
to find out which ones are using a specific table. Is
there anyway to do that besides going through each query?
Click to expand...

There are some good third-party tools to do this (they also look in
hidden queries such as combo-box row source SQL strings, which might
not be obvious!)

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