Table Cross Reference

This powerful report shows where and how each Microsoft Access table is referenced across the entire database. Knowing where your tables are used is critical to understanding your application and very important before modifying, renaming, or deleting them.

In this example, you can see for the Categories and Customers tables, where they're used (called). Within each grouping, the calling object type and name are listed along with the reference property name. Sometimes the table is referenced directly from a form's recordsource or within a query, and other times it may be referenced through a control like a combo box. Tables can also be referenced from other tables as a combo box (notice how the Categories table is referenced by the Product table's Category ID field). Trying to generate this information manually would be extremely time-consuming and inaccurate. Total Access Analyzer examines your entire database as a whole to generate this extensive cross-reference information.

Unused Table Analysis

Related to Table Cross-Referencing is the detection of unused tables. By determining everywhere tables are used, Total Access Analyzer determines tables that aren't used. The list of unused tables (and other Access objects) is provided under Suggestions.

NOTES

• The Resolved? column is checked if the table exists (if it doesn't an error appears in the Error reports).
• The Variable? column is checked if a variable containing a table name is referenced in code.