Determine which tables are no longer used

[arnelgp]

I would suggest TotalAccessAnalyzer from https://www.fmsinc.com/.

will satisfy only the requirement on post#1, which is to determine table not being used.
also, the code is free while the Analyzer is not.

 

[isladogs]

My first step would be to save all the objects in the database using the SaveAsText (hidden), Then use a text editor (such as which allows you to Find In Files to search for usage of each file in your database. Those not referred to should be a good first cockshy at not used. Would be very simple to automate using a list of table names in VBA.

All of that is also available in the free Access Dependency Checker and V-Tools apps - see links in post #18

 

[DickyP]

All of that is also available in the free Access Dependency Checker and V-Tools apps - see links in post #18

Agreed but this needs nothing except a text editor!

 

[isladogs]

Plus a lot of time or code to automate it. The utilities make the process much easier

 

[DickyP]

Plus a lot of time or code to automate it. The utilities make the process much easier

As I said I agree with you that the utilities are the answer: my recommendation (which is no more than a couple of hours work) would be a first indication to give an idea if any real work is necessity. My experience is that any inherited database is far more work than one expects even if it looks easy.