finding tables assoicated to queries

[Guest]

I have hundreds of queries getting records from 20 different tablles. Now I
have to change one of those tables and need to know if there is an easy way
to find out which queries use which tables without have to go through each
query and mapping each one. The reason I need to know this is in Acess when
you make changes to a Table strange thing happens in the queries.

 

[Guest]

Use TOOLS - Analyze - Documentor. Select all the queries and SQL in the
options. Run and save to Word. Search in Word to find all.

 

[John Spencer]

Spend a few dollars and save yourself lots of time and trouble.

Products to do a global find and replace. All have Access 97 and later
versions. Some don't have an Access 2003 version, but may still work with
Access 2003.

Shareware (Try and Buy):
Find and Replace http://www.rickworld.com

Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com

Total Access Analyzer http://www.fmsinc.com

Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace

 

[Marshall Barton]

I have hundreds of queries getting records from 20 different tablles. Now I
have to change one of those tables and need to know if there is an easy way
to find out which queries use which tables without have to go through each
query and mapping each one. The reason I need to know this is in Acess when
you make changes to a Table strange thing happens in the queries.

See if this kind of procedure (air code) makes your job a
little easier.

Public Sub FindQueries(strTblName As String)
Dim db As Database
Dim qdf As QueryDef

Set db = CurrentDb()
For Each qdf In db.QueryDefs
If qdf.SQL Like "*" & TblName & "*"
Debug.Print qdf.Name
End If
Next qdf

End Sub