How to determine what tbls are linked to queries

[Bat Dude]

Hi all,

I have a long evolving Access DB that I need to clean up. I have added multitudes of queries and tables over the past year or so and need to create a "clean copy" with only the forms and queries and tbls and remove all those not interlinked.

The programmer who assisted me eons ago is not available. A lot of frms are linked to VBA code and queries so I do not want to simply start deleting tbls or qrys w/o verifying they are not linked to the function of the entire DB.



Is there a way to do this?

Cheers,
Bst Dude

[isladogs]

Several ways
1. Use the built in Object Dependencies feature in the Database Tools ribbon
This will allow you to check database objects like forms, reports and queries.
However it will not check vba code

2. Obtain an addin such as V-Tools (free) or MZ Tools (not free but well worth the cost)
These will allow you to check code as well.

Don't forget to check row sources of listboxes and combos etc

Having said that, the safest way is often to rename items by prefixing with e.g X and see if the db fails to compile or anything stops working
If not, it should be safe to delete