Any way to clean up/audit databases?

[hmanvel]

Due to my totally unstructured method of creating databases, I sometimes find that the databases are containing old tables, queries, etc. that are no longer necessary. However I really can't be sure so I just leave them to take up space. Is there any means within Access to run an audit to see which of these the program is dependant upon and which are just old garbage?

 

[Rabbie]

If you have Access 2003 or later there is an option in the View window called Object dependencies which will let you see what is dependent on what. Hope this helps.

 

[cat001969]

Make sure you select the Table, Query, etc to view its dependencies

 

[hmanvel]

Thanks for the advice; unfortunately I'm using Access 2000. Should have mentioned that. Can't find a similar feature in the view menu.

 

[Rabbie]

Thanks for the advice; unfortunately I'm using Access 2000. Should have mentioned that. Can't find a similar feature in the view menu.

I think this feature was introduced for A2003 possibly A2002. I am pretty certain it was not available in A2000.