How to tell which Objects are being used (Access 2007)

RenaG

Registered User.
Local time
Today, 16:15
Joined
Mar 29, 2011
Messages
166
I have a DB that I would like to clean up. Is there an easy way to tell which objects (tables, queries, forms, etc) are being used and which ones are not? TIA!
 
I figured it out. When I opened a query, I noticed on the Database Tools tab the Object Dependencies option. When I clicked it a window popped up telling me that I had to turn on AutoCorrect for that feature to work. (BTW - there is a good explanation of AutoCorrect in Help.) It asked if I wanted to do that so I clicked yes. It took a minute or two for Access to get the log file set up. So far, it looks like this is just what I was needing.

I hope this is useful for somebody else.
 

Users who are viewing this thread

Back
Top Bottom