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

New Features of Total Access Analyzer for Microsoft Access 2016

The most powerful Microsoft Access database documentation and analysis program is now available for Microsoft Access 2016.

Total Access Analyzer helps you know:

  • Exactly what's in your database
  • How objects are related to each other
  • How the VBA code calls each other
  • A variety of other tips and suggestions to improve and fix your databases

Total Access Analyzer supports all the features of MS Access 2016 with additional enhancements from the 2013 version to extend its functionality and improve its use based on our experiences and customer feedback.

Microsoft Access Database Documentation and Analysis Wizard
Main Form for Total Access Analyzer 2016

Enhancements

We've made many enhancements since the previous version for Microsoft Access 2010:


Microsoft Access 2016 Support

Supports Microsoft Access 2016, 32-bit and 64-bit versions

Total Access Analyzer 2016 includes a 32 bit and a 64-bit version of its add-in to support both versions of Microsoft Access 2016. The setup program automatically detects the Access 2016 version you've installed and installs the appropriate one. It supports any operating system (32 and 64 bit) that Access 2016 supports.

Document All Database Types Supported by Microsoft Access 2016

Total Access Analyzer supports all the database types Microsoft Access 2016 uses including:

  • ACCDB database format (from Access 2007 and 2016)
  • Jet Engine/MDB formats (from Access 2000, 2002, 2003, 2007, 2010, 2013, 2016)

This means you can use Total Access Analyzer 2016 with Microsoft Access 2016 to document and analyze databases created by older versions of MS Access.

Note that Access 2016 no longer supports Access Data Projects (ADP) linked to SQL Server, so Total Access Analyzer 2016 cannot support them either.


New Suggestion: Incorrect Link to Subforms

The LinkMasterFields of a subform should be to a control on the master form and not directly to a field in the formís recordsource. This lets the subform refresh when the user edits the controlís value rather than waiting for the record to be saved. Total Access Analyzer detects this mistakes and offers a new suggestion to when itís discovered.

See our paper Microsoft Access Subforms Should Reference the Control Rather than Field for Master Link Fields for details.


New Suggestion: Relationship Field Cross-Reference and Field Type Comparison

Total Access Analyzer generates field cross-reference for the relationship joins and makes sure they are defined with the same data type. If not, a suggestion is offered to review the inconsistency.


Enhanced Cross-Reference of Aliased Tables in Queries

Total Access Analyzer 2016 performs more advanced SQL parsing to capture table names aliased in SQL Joins. Previously, only tables aliased in the FROM clause were resolved.


Pass-Through Queries are Not Cross-Referenced

Pass-through queries are processed by the back-end linked server that they are passed to and not Microsoft Access. Since Access and Total Access Analyzer cannot "see" the objects and functions there, table and field cross-reference errors were being identified. To avoid such noise, Total Access Analyzer no longer cross-references pass-through queries. It can still document its SQL and other properties including columns if the connection string is provided. If the connection string is not provided, it flags the omission as an error.


Windows 10 Support

Total Access Analyzer 2016 supports all operating systems supported by the desktop version of Microsoft Access 2016. For Windows 8 and 10, the productís Windows shortcut menu is under "Total Access Analyzer 2016". In earlier versions, itís under "FMS", then "Total Access Analyzer 2016".


New Manual and Context Sensitive Help

Updated manual and help file with detailed documentation of how the program works and how to best use it.


Pricing and Microsoft Access Versions

Due to the differences within each version of Microsoft Access, there is a separate version of Total Access Analyzer for each version of Access.

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.

Additional Resources