Thank you for making Total Access Analyzer the most popular Microsoft Access add-in program of all time. With the release of Total Access Analyzer for Microsoft Access 2019, version 17.1, we've created an update for Total Access Analyzer for Microsoft Access 2016. Version 16.7 replaces 16.1 and includes new features and improvements based on our experiences and customer feedback.
Main Form for Total Access Analyzer 2016
We've made many enhancements since version 16.7:
Introduced with Access 2007, you can create custom ribbons for your application and/or individual forms and reports. Ribbons are defined in the UsysRibbons table as separate records in XML format. Total Access Analyzer documents each ribbon, their references to other Access objects, where ribbons are used, and unused ribbons.
Each ribbons appears in the Treeview as a separate item.
If a ribbon references another object (like a table or procedure), it appears in the cross-reference reports for those objects and on the XREF tab on the View Explorer.
Three new reports are available under Database:
Data Macros were introduced in Access 2010. Data macros are triggers that execute when table events occur. They have logic, can update other tables, and run other data macros.
Total Access Analyzer now parses data macro code to document what they do and the objects they use. Data macros now appear on the View Explorer in a folder under its table with each data macro listed.
Three new reports are available:
The Database Summary report add a new section for the number of data macros and data macro lines in the database.
Our SQL parser detects more references to tables, queries, fields and controls across your database objects and table alisases. References to fields or controls in subforms are also analyzed to make sure they exist.
These issues are now detected:
Additionally, previous suggestions to convert VBA string command to explicit string functions (e.g Mid$ instead of Mid) are no longer suggested.
The report list for the Main Documentation and Quick Doc, adds a text filter for report name. Type a few letters to narrow down the list of reports:
The Category column is also enabled so you can select and filter on it.
We've added two new reports for queries that reference forms and control:
When migrating Access databases to other platforms like SQL Server, itís helpful to know which queries have dependencies on VBA functions and your own procedures. Total Access Analyzer has four new reports to show which queries have these dependencies:
Four new reports are available to show the ControlSource of controls on forms and reports. This makes it easy to see direct field references and expressions (calculated fields) placed on your forms and reports:
Three new reports are available to see the properties associated with Combo Box and List Box controls, and controls with validation properties:
Two new reports show where controls are referenced from other objects. For instance, a form may reference a control in subform, or a report referencing a value from a currently opened formís control:
Additionally, we capture module variables that reference other object like opening a form or recordset:
Total Access Analyzer reports can be displayed in Print Preview or Report View. For Report View, you can filter the data while you view it. Some of our reports used expressions to combine fields (e.g. Object Type and Object Name) which prevented the ability to filter them. Where possible, the object type and object name are separated into their own controls so they can be filtered in Report View.
Report sets let you define multiple reports in a group for easy retrieval and printing. By default, these settings are saved in the TAA_Rep.mda database in the userís Total Access Analyzerís folder. You can now point to a database on a shared network drive so multiple users and machines can reference the same set of reports.
Copy the TAA_Rep.mda then point to it under Report, Options, Report Set Location tab:
In addition to Ribbons and Data Macros, the View Explorer supports resizing better and offers more features:
While viewing the documentation results, if you adjust column widths, the settings are saved and applied the next time you view it. Your columns widths are similarly preserved when viewing the Search results.
When viewing the list of issues (on the Errors, Suggestions and Performance tabs), you can check off the items that are Reviewed to focus on the remaining ones. The status is maintained if you document the database again. There is a Filter button to select the list by issue type. The filter shows the number of instances discovered for each type. It now shows the number youíve reviewed and not reviewed to make it easier to select.
Issue Filter with New Reviewed and Not Reviewed Counts by Issue Type
Quick Doc is enhanced in many ways:
A new [Check for Updates] button contacts our website to see if the current version of Total Access Analyzer is the latest version. You may be eligible for a free update.
The user manual and help file are updated.
New icons, larger fonts, and larger forms are used where appropriate to provide a more modern and readable user experience.
For instance, the database name on the main forms is enlarged, icons on the View Treeview updated, and the second page of the Documentation Wizard uses icons and shortened option names:
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||Buy Now|
|5-Seat||$599||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Update to the Latest Release within the Same Version
|Single||$149||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$449||Buy Now||Buy Now||Buy Now||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 16.7 for
Microsoft Access 2016
Version 15.7 for
Microsoft Access 2013
Version 14.7 for
Microsoft Access 2010
Version 12.97 for
Microsoft Access 2007
Version 11.95 for
Microsoft Access 2003
Version 10.8 and 9.8 forr
Access 2002 and 2000