Is there an Access "Where Used" type utility? 1

[BTilson]

I have a massive access database that is used daily where I work. It quite often reaches well over a gig in size, and has hundreds of queries, tables and reports.

Quite often when I need to work on some aspect of the DB, I need to figure out exactly what else references the object I'm working on. Basically I am looking for a utility that would tell me what other objects use or reference the chosen object. Say I choose a table, I would want the utility to tell me all queries or reports that have anything to do with that table.

Does something like this exist? If you need any more information, please do not hesitate to let me know.

Thanks in advance!

Brooks Tilson
Database Development
Tilson Machine, Inc.

 

[PHV]

Have a look here:

http://www.speedferret.com/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BTilson]

Perfect, and more! This does EXACTLY what I wanted, along with a lot of extra functionality.

Thank you VERY much!

Brooks Tilson
Database Development
Tilson Machine, Inc.