Determine where tables are used

  • Thread starter Thread starter cbaird
  • Start date Start date
C

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.
 
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.
Click to expand...

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

Access 2003 has a new tool to see object usage and dependencies.
 
Armen Stein said:
Access 2003 has a new tool to see object usage and dependencies.
Click to expand...

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
 
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
Click to expand...

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.
 
Back
Top