Queries that store particular table

[Derek]

Hi Guys

Is there any way to find out which queries are using my specific table in MS Access?

Instead of checking each and every query , is there any other way to know which queries are using that specific table (e.g tblAudit)?

Many Thanks

 

[Minty]

The dependency checker will do that for you, depending on which version of Access you are using

 

[Derek]

I'm using Access 2010. how to use dependency checker?

 

[CJ_London]

select the database tools tab

select the required table (don't open it)

click on object dependencies

this will show queries/forms/reports which use the table as a recordsource.

It will not show forms/reports with combos or list boxes using the table as a rowsource, nor textboxes using a domain function on the table, nor will it look at VBA to see if you have referenced the table in code.

If you need to go to this level of detail you will need a special tool - there are a number around - take a look in the code repository or google online

 

[Pat Hartman]

You need to have Name Auto Correct turned on to use the dependencies feature. Don't remember to turn NameAutoCorrupt off when you are done.

Total Access Analyzer by FMSINC.com is a good all around tool with tons of reports.