Determine where tables are used

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cbaird - 19 Jan 2004 13:45 GMT

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.

Reply to this Message

Roger Carlson - 19 Jan 2004 13:54 GMT

Rick Fischer's "Find and Replace" is the tool I use. You can find it here:
http://www.rickworld.com/download.html

Signature

--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

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

Reply to this Message

John Vinson - 19 Jan 2004 18:15 GMT

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

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message

Armen Stein - 20 Jan 2004 17:34 GMT

> >I would like to find all the queries that have used a
> >particular table. Is there any tool that will accomplish
[quoted text clipped - 6 lines]
> Come for live chats every Tuesday and Thursday
> http://go.compuserve.com/msdevapps?loc=us&access=public

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

Signature

Armen Stein
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com

Reply to this Message

Allen Browne - 21 Jan 2004 10:46 GMT

"Armen Stein" <Armen_RemoveThis_@RemoveThis_JStreetTech.com> replied:

> 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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Reply to this Message

Armen Stein - 21 Jan 2004 14:33 GMT

> "Armen Stein" <Armen_RemoveThis_@RemoveThis_JStreetTech.com> replied:
> >
[quoted text clipped - 7 lines]
> 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.

Signature

Armen Stein
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com

Reply to this Message