Linked table - Is it queried?

[Scottie31]

Is there an easy way to find out which queries are linked to a specific table? I have a database that has approximatly 1100 queries and need to know if a certain table is actually being used but I don't want to go through each query.

Thanks.

 

[boblarson]

You can use the V-Tools' Total Deep Search (free) from here:
http://www.skrol29.com/dev/en_vtools.htm

Or if you want a more powerful tool set (Rick Fisher's FIND & REPLACE):
http://www.rickworld.com/products.html
That one costs money, but it is well worth it.

 

[Pat Hartman]

Newer versions of Access also include a tool to find dependencies. It requires that you turn name auto correct on. Then right click on the table and choose the dependencies option.