searching code and queries for text

[Mark Andrews]

What's a good utility to search through all the code and queries for a text
string?
Example: I'm removing a field from a table and need to find out where that
field is used.

Access2007.

The only one I remember is Speed Ferret but their website looks kinda old.

I haven't used a utility like this for a long time. Willing to pay a few
bucks if needed.

Thanks in advance,
Mark

 

[Arvin Meyer [MVP]]

There is the built in Find mechanism for code, but for everything else, you
need a program like Speed Ferret or Find & Replace. Only Find & Replace
works with Access 2007.

http://www.rickworld.com/products.html

 

[Mark Andrews]

Thanks I'll take a look.
Mark

There is the built in Find mechanism for code, but for everything else,
you need a program like Speed Ferret or Find & Replace. Only Find &
Replace works with Access 2007.

http://www.rickworld.com/products.html
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Clifford Bass]

Hi Mark,

Just use the free built-in database documenter. After the report has
been generated, save it as a PDF. You can then search the PDF for all
instances of the field.

Clifford Bass

 

[Mark Andrews]

excellent suggestion! I haven't used that for a while, forgot about that
one.
Mark

 

[Clifford Bass]

Hi Mark,

Glad to help.

Clifford Bass