Determine where tables are used

[cbaird]

I would like to find all the queries that have used a
particular table. Is there any tool that will accomplish
this? Thank you for your help.

 

[John Vinson]

I would like to find all the queries that have used a
particular table. Is there any tool that will accomplish
this? Thank you for your help.

Not builtin within Access; but there are several third-party vendors
who have written such tools.

 

[Armen Stein]

Not builtin within Access; but there are several third-party vendors
who have written such tools.

Access 2003 has a new tool to see object usage and dependencies.

 

[Allen Browne]

Access 2003 has a new tool to see object usage and dependencies.

That tool only works if you have the Track Name AutoCorrect box checked
(Tools | Options | General). If you are trusting this "feature", you may not
be aware of the number of known problems it has. For a list of well over a
dozen of them, see:
Failures caused by Name Auto-Correct
at:
http://allenbrowne.com/bug-03.html

 

[Armen Stein]

That tool only works if you have the Track Name AutoCorrect box checked
(Tools | Options | General). If you are trusting this "feature", you may not
be aware of the number of known problems it has. For a list of well over a
dozen of them, see:
Failures caused by Name Auto-Correct
at:
http://allenbrowne.com/bug-03.html

I agree that the Track Name AutoCorrect feature should be turned off
under normal circumstances, and in any case should not be enabled when
the application is delivered.

However, many of the problems occur when actual name changes are
enabled. It's possible to turn the just the tracking portion on, check
object dependencies, then turn it back off again. This approach could
be considered if no other search tools (e.g. Speed Ferret) are
available.