Microsoft Access Table Cross Reference

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.

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. See Finding and Deleting Unused Access Objects and Code for more details.

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.

---

Total Access Analyzer Reports for Microsoft Access Tables

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.

Basic Table Lists

Simple lists to gain a quick understanding of all the tables in your database and their relative size

• Table List, Sorted by Table Name
• Table List, Sorted by Table Type (to see tables by linked data source)
• Table List, Sorted by Number of Records
• Table List with Estimated Sizes, Sorted by Number of Records
• Table List with Estimated Sizes, Sorted by Tables Size
• Table List Details, Sorted by Table Type

Table Properties

• Table Properties, Sorted by Table Name
• Table Properties, Sorted by Property Name

Table Fields

Examine fields lists for each table, or for each field which tables its in, along with their properties

• Table Fields, Sorted by Table Name (Portrait and Landscape versions)
• Table Fields, Sorted by Field Name (Portrait and Landscape versions)
• Table Fields, Sorted by Data Type and Size Summary
• Table Fields, Sorted by Data Type and Size Detail
• Table Field Properties, Sorted by Table Name
• Table Field Properties, Sorted by Field Name
• Table Field Properties, Sorted by Property and Table
• Table Field Properties, Sorted by Property and Field

Table Field General 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.

• Table Field General Properties
• Table Field Lookup Properties
• Table Field Property Slice DefaultValue
• Table Field Property Slice Format
• Table Field Property Slice InputMask
• Table Field Property Slice Required
• Table Field Property Slice RowSource and Type
• Table Field Property Slice Validation Rule and Text
• Table Fields with Different Types (detects inconsistent field definitions)

Table Indexes

Examine indexes and their fields and properties

• Table Indexes, Sorted by Table Name
• Table Indexes, Sorted by Fields
• Table Index Properties, Sorted by Table Name
• Table Index Properties, Sorted by Property and Table
• Table Index Properties, Sorted by Property and Index

Table Dictionaries

Detailed listing of each table, its properties, indexes, fields, etc.

• Table Dictionary
• Table Dictionary with Field Properties

Table Cross Reference

• Table Cross Reference (where tables are used)
• Field References Sorted by Field Name
• Data Flow Diagram (multi-level cross reference)

---