Searching for text in an MS Access MDB File

[whdyck]

I'm using MS Access 2003.

I'd like to be able to search all non-table objects in a given MDB for a given text string. Is this possible? I want to know which MS Access objects contain the specified string. (I haven't seen anything in the menus that looks promising.)

My intention is to identify dependencies: if I want to delete, say, a query, I want to be sure that nothing references it. Yes, I know that there's an Object Dependencies option, but there are some Unsupported Objects that Object Dependencies cannot work with. I have union queries and subqueries that would be a problem for Object Dependencies.

Thanks for any help you can give.

Wayne

 

[boblarson]

This is the best tool I've found for that:

http://rickworld.com

I use it at work and it is worth the cost.

 

[whdyck]

Looks like just what I need.

Thanks!