How to find all object references?

[Guest]

Hi all,

I know that question must have been asked before, but I can't find it.
Let's say I have a table or query. Is there a facility in Access in which,
when invoked, would tell me where what query or what portion of the code make
reference to it.

I tried Tools->Analyze->Documenter, but it really does not give the
infomation I am looking. I just want a list of places where a reference to a
particular table/ query whether it be in the code, query , report, form,
macro...etc. Thank you for sharing your thoughts.

Ben

 

[Douglas J Steele]

You really need to look at 3rd party tools, such as Total Access Analyzer
from FMS
http://www.fmsinc.com/products/analyzer/index.html

 

[Guest]

Douglas,

Thanks for sharing with me on the tool. My follow up question, There's
nothing resembling FMS's tool in Access at all? Thanks again.

Ben

 

[Douglas J Steele]

No.

 

[George Nicholson]

If there was, FMS wouldn't be in business

 

[Larry Daugherty]

There are a couple of other possibilities:

Find And Replace from Rick Fisher at www.rickworld.com It's shareware
and works a treat.

Speed Ferret from www.moshannon.com/ It's a commercial product and is
also highly recommended in the Access groups.

HTH

 

[Guest]

Thanks Doug
--

No.

 

[Guest]

Larry,

Thank you for your suggestions, that was very helpful.

Ben