Find all instances of a query?

[Guest]

Hi all,

I would like to find all areas in my code where a certain query is used -
this would also include if that query was called by another query, etc.

Is there a tool - anything - that will search throughout the entire database
and find all the occurences?

TIA
Megan

 

[John Vinson]

I would like to find all areas in my code where a certain query is used -
this would also include if that query was called by another query, etc.

Is there a tool - anything - that will search throughout the entire database
and find all the occurences?

Several - but Microsoft didn't write them:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

John W. Vinson[MVP]

 

[Guest]

Several - but Microsoft didn't write them:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

John W. Vinson[MVP]

Thanks John...
From what I can see, those seem to be just what I am looking for, however, I
am using Access 97 and none of those tools support that version. You
wouldn't know of one that would do you?

 

[Guest]

Sorry John,

I wasnt looking hard eneough at the web pages - I see that some do in
fact support 97 - Thanks Again!!!