Identifying all objects using a particular table

[wyld]

I'm intheriting an Access 97 database that I need to change. I'm adding 4 fields to a table, tblPolicy. I want to find any queries, forms, reports, macros and modules that use this table so I know what will be impacted by making the change.

Once I've identified what uses the table, I need to search on the object using it. For example, I know the query qrptPolicy and form frmPolicy use tblPolicy. Now, I want find everything that uses qrptPolicy and frmPolicy.

I tried using the Search, but I couldn't find anything similar.

Any ideas?

Thanks in advance

 

[MichaelRed]

AFAIK, there is no "silver bullet" for this without paying for the silver. "Speed Ferret" claims to do it - for the price.

For cheap soloutions, MSys* Tables in '97 have a "wealth" of information on the objects in the db, including field names references in tables and queries. Since Fotrms and Reports are MOSTLY based on the tables and queries, you can get pretty close by understanding these (MSys* tables). For modules and (UGH!) macros, you just have to search them for occurances.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over