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"?
a specific table, without opening each query and doing a
visual search, or a "find"?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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"?
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