Where used

  • Thread starter Thread starter Rafi
  • Start date Start date
R

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
 
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
 
Back
Top