How to FIND tables and columns in queries

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

Guest

I want to find in which queries a table or column is being used. I have
about 100 queries in my system and wantto know which ones reference certain
columns.

Is there a simple way to do this or perhaps someone has already written a
simple macro/VBA to do this?

Thanks,
 
I want to find in which queries a table or column is being used. I have
about 100 queries in my system and wantto know which ones reference certain
columns.

Is there a simple way to do this or perhaps someone has already written a
simple macro/VBA to do this?
Click to expand...

There are some useful tools for this kind of searching:

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

You could write VBA code to loop through the Queries collection, and
using InStr() to find the field or table name in the query's SQL
property.

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