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 2003Total Access Analyzer Version X.8 : New Features for Microsoft Access 2003, 2002, and 2000


Total Access Analyzer 2003, Version 11.8 is not the latest version.
Version 11.95 was released in 2015 with many new features.
Existing 11.8 customers can upgrade for a nominal fee. Visit Version 11.95 for details.


FMS is pleased to provide a major update to Total Access Analyzer for Microsoft Access 2003, 2002, and 2000. Total Access Analyzer is the world's most popular Access product.

The X.8 versions of Total Access Analyzer include many new features and enhancements to help you create and maintain Microsoft Access databases better than ever! These new versions are now available:

New Versions

Total Access Analyzer version X.8 is an upgrade from version X.7. These are the new versions:

Access Version New Version Previous Version
Access 2003 11.8 11.7
Access 2002/XP 10.8 10.7
Access 2000 9.8 9.7

If you have a version prior to the X.7 version, click here to see the features that were added in X.7, which are also part of the X.8 version.

New Features and Enhancements

Total Access Analyzer X.8 builds on its heritage of helping Access enthusiasts create better Access solutions with a wide range of new features. We've added many enhancements based on our experiences and the recommendations of our customers. Thank you very much! We hope you like the results:

Main Screen Redesign

Main screen shows the context of the currently documented database and your ability to view, search, and print reports for it.

Total Access Analyzer Main Menu for Microsoft Access 2003, 2002, and 2000

You can also open it without closing your current objects.

New, Sleek, More Modern User Interface

  • Completely redesigned user interface to support the sleeker Windows Vista/XP color schemes, and look and feel

Reporting Enhancements

Individual or multiple reports can be exported to formats such as HTML, Snapshot, Text, or RTF to a folder you specify:

Export Reports to Multiple File Formats: such as HTML, Snapshot, Text, or RTF

Reports can be sent to the new Report View which supports your ability to filter the results interactively

New Reports

There are 336 professional quality reports. Here are some of the 24 new reports:

  • Import Export Specifications
  • Objects with Identical SQL and RecordSource
  • Several reports for unused objects and code including:
    • Unused forms
    • Unused reports
    • Unused queries and tables
    • Unused forms, queries, reports, and tables
  • Enhanced Database Summary reports
  • Table field property slice reports to see a property across multiple tables and fields:
    • Validation Rule and Text
    • Input Mask
    • Format
    • RowSource and Type
    • Required
    • Default Value
  • Table field report showing all the General tab properties
  • Table field report showing all the Lookup tab properties
  • References to form and reports controls in VBA code

After documentation, reports without data are not listed to make it easy to see what's available.

Viewing Results (Documentation Explorer)

Microsoft Access Database Documentation Results in Total Access Analyzer's Documentation Explorer

  • One click loading of the current object in design view. Whether it's from the Diagrams, XREF, Errors, Suggestions, or Performance Tips tabs, you can press Alt+D and put it in design mode to immediately review the object or module for the changes to make.
  • Significantly improved performance when viewing results, and looking at detailed property lists for one object or across all objects of one type
  • Improved maximized mode with splitter bar between panes

New Suggestions and Performance Tips

Total Access Analyzer detects 270 specific types of errors, suggestions, and performance tips for your database. Here are some new ones 

  • Eliminate/Consolidate duplicate queries: Identical SQL Analysis to determine if the same SQL string is used across multiple queries, or the record source and row source of forms and reports
  • Unused forms and reports
  • Module analysis:
    • Use of old constants from pre-Access 97 syntax
    • Procedures with exits in the middle of its body which could bypass cleanup code at the end of the procedure
  • Date fields with input masks (the Format property should handle this)
  • Forms with the Moveable property set to No
  • Forms with unnecessary scroll bars

Here's a complete list of Best Practices detected by Total Access Analyzer.

Search Enhancement

Search lets you find any string among the documented objects, macros, and modules. While viewing the search results, you can put the object in the current record into design mode by pressing Alt+D or the Design button:

Search Results for Microsoft Access documentation

New Module VBA Documentation

  • Detects table and query references from the open command of ADODB recordsets and adds this to the Object XREF views and reports
  • Detects explicit control references from code (e.g. Form_MyForm.txtValue) with new Object XREF reports

Improved Documentation Wizard

When creating new documentation, the Documentation Wizard lets you work more efficiently. It:

  • No longer requires your code to be compiled (with a warning)
  • Adds a Finish button so you can skip the last two pages after you select your objects to document

New Installation and Storage Locations

Total Access Analyzer addresses the limitations imposed by Vista and User Access Control. Rather than storing output databases for your documentation in the Total Access Analyzer folder by default, it now stores it in your Application Data folder.

For a quick overview of Total Access Analyzer, Take the Tour.


Pricing and Access Versions

Due to the different features in each Access version, Total Access Analyzer has a separate versions corresponding to each version of Microsoft 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