How to determine which queries use a specific table

L

Linda

Is there an easy way to determine which queries are using
a specific table, without opening each query and doing a
visual search, or a "find"?
 
J

John Vinson

Is there an easy way to determine which queries are using
a specific table, without opening each query and doing a
visual search, or a "find"?
Click to expand...

Not easily. There are third-party tools to ease the process:

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

The Query's SQL property isn't exposed in either MSYSQueries or
MSYSObjects, annoyingly enough!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Duplicates in Query 0
determine which time interval the date falls into 6
Cleaner way to query for negatives? 3
Numeric Field Overflow when appending date - how to convert it to text 1
jump to specific table 1
Union Query of Queries 4
Counting multiple memberships 1
Tables and Queries 1

Top