If you are running A2003, you can right click on the table and choose the
Object Dependencies item.  This feature needs to turn on the Name Auto
Correct feature to work but you can turn off Name Auto Correct again when
you are done.

I've been using Speed Ferret for about 5 years.  Although they still don't
have a version that works exclusively with Office 2003, if you have Office
2000 or XP, you can uninstall 2003, install the earlier version, and then do
a "custom" reinstall of 2003, overwriting everything but the earlier version
of Access.  This will give you Access 2003 and the ability to use Speed
Ferret.  They indicate that they are working on a new version, but have been
saying that for 3 years.

It is an Search and Replace tool for Access and SQL Server that works great.
If you have hundreds of queries, and need to make changes to a field name,
table name, or some other object in your database.  This will pay for itself
the first time you use it.

Dale

There are a couple of tools that handle this nicely:

Find and Replace from Rick Fisher at www.rickworld.com
It's a shareware product.

Speed Ferret from www.speedferret.com
It's a commercial product.

Both get good reviews.

HTH

Here's the code I use to find which queries use a particular column in all
queries. Looking at it, it just looks for a piece of text occuring in the
sql, so it would find tables as well.
Paul Shapiro

   Dim qdf As DAO.QueryDef
   Dim strOut As String

   strOut = "Searching for the string: " & strFieldname

   'Search the querydefs
   strOut = strOut & vbCrLf & "Used in Queries: "
   For Each qdf In CurrentDb.QueryDefs
       If InStr(qdf.SQL, strFieldname) Then
           strOut = strOut & vbCrLf & "   " & qdf.Name
       End If
   Next