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

Total Access Analyzer
Document, Analyze, and Detect Errors in your Databases

Total Access Analyzer for Microsoft Access 97

Discover why Total Access Analyzer is the most popular Microsoft Access add-in and the winner of EVERY Best Access Add-in award since 1994!

Information Booth
Product Highlights
Feature Summary
Pricing and Availability

Rave Reviews
Available Reports
Licensing Information
Download the Trial Version

Total Access Analyzer
I could summarize Total Access Analyzer in one sentence:
"You have to have this program!"
Thomas Wagner
Access Advisor Product Review

See the
Current Version!

 Click Here

1998 Readers' Choice Gold Award 1995 Readers' Choice Award 1994 Readers' Choice Award 1998 Readers' Choice Gold Award 1998 Readers' Choice Gold Award 1996 Readers' Choice Award 1996 Readers' Choice Award
Best Access
Best Access
Best Access

Product Highlights

Total Access Analyzer helps you create Access databases with more control and fewer errors.

Total Access Analyzer is the only program that analyzes all the objects in your database to determine how it works, and reveal links and potential problems. Unlike the built-in Access documenter that only looks at individual objects, Total Access Analyzer looks at all the objects. That's the only way to tell everywhere an object is used, objects and code that aren't used (e.g. queries, procedures, and variables you are afraid to delete), references to objects and fields that no longer exist, and many other potential problems.

Why you should get Total Access Analyzer

  • Catch errors before you distribute your Access database.
  • Total Access Analyzer catches runtime errors such as references to missing objects or fields, corrupt objects, invalid table links, objects calling procedures with the wrong number of parameters, etc. Over 100 types of errors, suggestions, and performance tips are offered. Why let your users or clients crash on bug Total Access Analyzer can automatically detect?
  • Taking over someone else's database or trying to understand your own database?
    Not sure how a database works? Total Access Analyzer gives you the detailed and summary information you need! Generate table/field listings, object cross-reference showing where each object is used, application flow diagrams, data flow diagrams, object diagrams, formatted bracketed module code printouts, and much more.
  • Get rid of unused objects and code.
    Do you have queries or code you're afraid to delete because you're not sure if they are used? Let Total Access Analyzer find your unused tables, queries, macros, sub-macros, forms, reports, procedures, variables, constants, and user defined types. Cleanup your database to make it faster and easier to maintain.
  • Make sure your fields are consistent across all your tables.
    Are you sure the same field has the same type across all your tables? Is the same numeric field sometimes an integer, long integer, and/or double? Are your text fields the same length? Total Access Analyzer catches these inconsistencies so you can quickly resolve them.
  • Improve your module code.
    Enhance performance and make your application more robust by finding modules without Option Explicit, procedures without error handling, procedures that should be private, variable scope conflicts, unnecessary debugging code, type cast omissions, etc.
  • Generate printed documentation of your Access database.
    Creating archival documentation of your database is a critical part of professional system development. Total Access Analyzer includes over 225 professional quality reports covering all aspects of your database. For many consultants who charge their clients for technical documentation, Total Access Analyzer pays for itself many times over. Impress your clients and bosses with extensive documentation showing the work you've done!

Feature Summary

Total Access Analyzer incorporates our extensive experience in building complex Access databases so you can too! Total Access Analyzer lets you deploy Access databases that are more robust and error-free than ever before. There are even performance tips to let you build faster applications. Here are some of its highlights:

  • Extensive documentation of every object in your database
  • Extensive analysis showing everywhere each object is used (object cross-reference)
  • Powerful module printouts with line numbers and bracketed source code loops
  • Three diagram reports showing Application Flow, Object Flow, and Data Flow
  • Detects over 100 types of errors and suggestions to improve your database
  • Finds unused objects: queries, macros, and code (procedures, variables, etc.)
  • Powerful Field Analysis to ensure your field names, types, and sizes are consistent
  • Relationship Window printouts
  • Powerful hierarchical tree view browser to see the results
  • Over 225 customizable reports
  • Runs from the Add-ins menu

Pricing and Availability

Versions are available for Access 2.0, 97, 2000, 2002, 2003, 2007, and 2010.

Total Access Analyzer Products
by Microsoft Access Version

License Price 2016 2013 2010 2007 2003 2002 2000 97

Single $299 Buy Now Buy Now Buy Now Buy Now Buy Now Buy Now Buy Now Buy Now
5-Seat $899 Buy Now Buy Now Buy Now Buy Now Buy Now Buy Now Buy Now Buy Now

Upgrade Between Access Versions

Single $199 Buy Now Buy Now Buy Now Buy Now Buy Now Buy Now Buy Now  
5-Seat $599 Buy Now Buy Now Buy Now Buy Now Buy Now Buy Now Buy Now  

Update to the Latest Version within the Same Version

Update 14.5 Update 12.95 Update 11.95 Update X.8 Features
Single $149 Buy Now Buy Now Buy Now Buy Now Buy Now  
5-Seat $449 Buy Now Buy Now Buy Now Buy Now Buy Now  

Premium Support Subscription

Single $299 More Information
5 Seat $999

Also Available as part of:

Total Access Ultimate Suite
Total Access Developer Suite

Runtime/Redistributable Version

Not Applicable

Licensing Information

Total Access Analyzer is licensed on a per user basis. Each user who runs the program must have a license. Read the License Agreement for details.