How to find all object references?

B

Ben

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
 
B

Ben

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
 
L

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
 
Top