Total Access Analyzer is the world's leading Microsoft Access add-in product and designed to help you create better Microsoft Access solutions through comprehensive documentation and analysis.
How do I get a list of unused objects with Total Access Analyzer?
1. From the Main menu, click on the View (Explorer) button. Click on the database (top level) in the TreeView. View the Suggestions tab. Unused objects are listed there. You can filter the list of suggestions shown by clicking on the Filter Items button. The types of unused objects include:
- Unused Class Property
- Unused Procedures
- Unused User Defined Type
- Unused User Variables and Constants
2. From the Main menu, click on the Report (Print) button. The information is available under the Suggestions area of the reports (left side of the 2 panel form). There are specific reports in this section for unused tables, queries, forms, reports, macros, procedures, properties, user defined types, and variables.
NOTE: The unused form and report suggestions are added in the 2007 and X.8 versions. Like all listings of unused objects, you need to be careful before deleting them because they may be used in ways Total Access Analyzer cannot detect (for instance interactive use or a table driven system with object names stored in tables). Look under Limitations in the help file to understand what Total Access Analyzer can or cannot detect.