The most powerful Microsoft Access database documentation and analysis program is now available for Microsoft Access 2016.
Total Access Analyzer helps you know:
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.
Main Form for Total Access Analyzer 2016
We've made many enhancements since the previous version for Microsoft Access 2010:
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.
Total Access Analyzer supports all the database types Microsoft Access 2016 uses including:
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.
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.
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.
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 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.
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".
Updated manual and help file with detailed documentation of how the program works and how to best use it.
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 Pricing
by Microsoft Access Version
|Microsoft Access Version|
|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||N/A|
|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
Also available as part of
Total Access Ultimate Suite
Total Access Developer Suite
|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.
Version 15.0 for
Microsoft Access 2013
Version 14.5 for
Microsoft Access 2010
Version 12.95 for
Microsoft Access 2007
Version 11.95 for
Microsoft Access 2003
Version 10.8 and 9.8 for Access 2002 and 2000