Total Access Analyzer

User manual

Microsoft Access 2016 Version
is shipping

new version

Version 15.0 for
Access 2013

Version 14.5 for
Access 2010

Version 12.95 for
Access 2007

Version 11.95 for
Access 2003

Versions 10.8 and 9.8 for Access 2002 and 2000

Access 97 Version

View all FMS products for Microsoft AccessAll Our Microsoft Access Products

Analyzer Info:

Why Analyzer?


"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

More Reviews

Additional Info:



Microsoft Access Database Documentation and Analysis: Total Access AnalyzerMicrosoft Access Design AnalysisMicrosoft Access documenter Download the trial version of the best Microsoft Access documentation program

Microsoft Access Query Cross-Reference

This report answers the critical question:

Where are my Microsoft Access queries used and referenced?

This powerful cross-reference report shows where and how each Microsoft Access query is used across your entire database.

In this example, you can see several queries and where they're used. Some are only used once, while others are used in multiple places. This is critical to know before modifying a query for one reference to it. Without knowing where and how the query is used elsewhere, you can easily fix one bug and create new ones.

Within each grouping, the calling object type and name are listed along with the reference property name. Trying to generate this information manually would be extremely timely and inaccurate. Total Access Analyzer examines your entire database as a whole to generate this extensive cross-reference information.

Microsoft Access Query Cross Reference Report

Part of the Unused Query Analysis

Do you have queries you think aren't used, but are afraid to delete because you're not sure? By performing the extensive cross-reference analysis to determine where queries are used, Total Access Analyzer also determines queries that aren't used. A separate Suggestions report lists queries that aren't referenced which are candidates for deletion. See Finding and Deleting Unused Access Objects and Code for more details.


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

Additional Resources