Need to remove unnecessary Objects

[Traininglady]

I need a program to remove objects that are no longer
being used by the database. I know I have Queries and
tables that are no longer being used by anything else. Any
Ideas?

 

[Art Mahon]

TrainingLady,

Notice no answers to your post. I have a similar requirement. An
alternative would be to somehow print out all tables, queries, forms,
macros, etc that are used in a particular report.
If you find an answer, I'd appreciate knowing.
Thanks,
(e-mail address removed)

 

[Douglas J. Steele]

Total Access Analyzer, from FMS, will help you identify objects that aren't
being used. I'm not sure whether it'll actually delete them for you, though.
Check http://www.fmsinc.com/products/analyzer/index.html for more details.

You can also use utilities like Find & Replace (see
http://www.rickworld.com/products.html for details) or Speed Ferret (see
http://www.moshannon.com/speedferret.html for details), but both of those
alternatives require more manual effort on your part.