This report answers the critical question:
Where are my Microsoft Access tables used and referenced?
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 CategoryID 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.
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. See Finding and Deleting Unused Access Objects and Code for more details.
Here's the complete list of the Total Access Analyzer reports documenting the tables in your MS Access database. Click on the hyperlinks for more information. Rather than overwhelm you with every report, we've provided a subset of the most interesting reports for you to review. The others show similar data but use different sort orders or filters.
Simple lists to gain a quick understanding of all the tables in your database and their relative size
Examine fields lists for each table, or for each field which tables its in, along with their properties
Look at all the properties of a field the way you would in the table designer or see a property value across all the fields that have them.
Examine indexes and their fields and properties
Detailed listing of each table, its properties, indexes, fields, etc.
Version 16.7 for
Microsoft Access 2016
Version 15.7 for
Microsoft Access 2013
Version 14.7 for
Microsoft Access 2010
Version 12.97 for
Microsoft Access 2007
Version 11.95 for
Microsoft Access 2003
Version 10.8 and 9.8 for
Access 2002 and 2000
"Total Access Analyzer is an amazing product that I've relied on and recommended for years. It's a huge time saver."
Sal Ricciardi, Programming Writer, Microsoft Corporation