Background

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. Total Access Analyzer offers more than 380 Reports, making it the most power documentation and analysis program for Microsoft Access professionals. 

Question

Will Analyzer locate everywhere a linked table is referenced inlcuding Module, Query, Form, and Reports? 

Answer

Yes and No. Total Access Analyzer documents every explicit reference to tables (linked or local) in an Access database. That includes references by queries, forms, reports, table relationships, and other tables (lookup lists).

From module code, explicit references to a table is documented in an OpenTable or DAO OpenRecordset command referenced either as an explicit string or constant. References through variables, expressions, user input, or table values are not possible to document.

Table cross-references are shown on the interactive Documentation Explorer screens, and in the Table Cross-Reference report:
http://fmsinc.com/MicrosoftAccess/Documentation/Reports/Table_CrossReference.html

Multilevel relationships are shown in the Data Flow Diagram to illustrate the hierarchy of objects that reference a table directly or indirectly:
http://fmsinc.com/MicrosoftAccess/Documentation/diagrams/index.html

This page discusses how Total Access Analyzer helps identify unused objects by documenting where every object is used
http://fmsinc.com/MicrosoftAccess/UnusedObjects/FindingDeleting.html
At the bottom of the page, the Eliminating Unused Objects and Code section describes some of the limitations that prevent Total Access Analyzer (or any program) from identifying references in code.

Additional Support Resources

• Support Options
• Product Information
• FAQs
• Updates
• User Manual
• PDF Fact Sheet