Where used

[Rafi]

I have inherited a DB that seems to have many redundant objects (tables and
queries). How can I determine what tables and queries are actually used by
other forms, reports of queries?

Thanks

 

[Michel Walsh]

In some Access version, you can right click on the table/query to get the
contextual menu with the "Object Dependency..." item. That does not cover,
though, table or query used from a string, such as a combo box control which
will have its rowsource property set to "SELECT f1, f2 FROM myTable1 WHERE
f3 = FORMS!form1!combobox24", as example.


Vanderghast, Access MVP

 

[Douglas J. Steele]

The best way I'm aware of is Total Access Analyzer, from FMS:
http://www.fmsinc.com/MicrosoftAccess/BestPractices.html

 

[Klatuu]

Here is an inexpensive tool I find very useful:

http://www.rickworld.com/download.html#FindAndReplace9

In addition, it does Where used and will also list items not used anywhere.