Microsoft Office Access 2010FREE Preview of Total Access Analyzer for Microsoft Access 2010

The Preview Version has expired.
The shipping version is expected to be available by the end of March 2012.


Thank you for your interest in the preview of Total Access Analyzer for Microsoft Access 2010.

Free downloads of the fully functional versions are available.


Microsoft Access Database Documentation and AnalysisAbout Total Access Analyzer for Microsoft Access

Total Access Analyzer is the most popular Microsoft Access add-in program of all time! Discover why so many Access users and developers rely on Total Access Analyzer to help them deliver higher quality solutions with fewer errors.

Basic Documentation of Individual Objects

Available as a Microsoft Access add-in, Total Access Analyzer generates comprehensive documentation of your MS Access database so you can understand how it works. From basic documentation and reports of individual objects you can see table field definitions, printouts of macros, formatted bracketed module printouts, form and report blueprints with annotated controls, etc.

Documentation Across Objects

Total Access Analyzer also provides information across objects to generate a field dictionary to see all the tables where a field name is defined, property slices to see a property value across multiple fields or objects, etc.

Object and Module Cross-Referencing

More importantly, extensive object and VBA code cross-referencing is performed so you can see everywhere an object is referenced, where every procedure is called, DoCmd used, ActiveX control inserted, etc. The Application, Data and Object Flow diagrams show how the program and data flows across your application so you can see multi-level references.

Error Detection and Best Practices Suggestions

Total Access Analyzer detects and offers 291 different types of errors, suggestions, and performance tips. Use them to improve you Access database applications.


What's New

For Microsoft Access 2010

Microsoft Access Database Documentation and Analysis Wizard

Total Access Analyzer 2010 (version 14) adds many new features since Version 12 was released for Microsoft Access 2007:

  • Support for Microsoft Access 2010
    • Supports Microsoft Access 2010, 32-bit version
    • Documents all the new object properties, macro commands, and VBA commands in Microsoft Access 2010
    • Improved User Interface with Office/Access 2010 Theme Support
    • VBA parser enhanced to support module code with compiler directives for VBA7 and 64 bit versions
  • New Documentation Options
    • Module XRef (cross-reference) is allowed even if all modules are not selected
  • New Errors Detected
    • Macro line analysis to detect missing command arguments
    • Form has Timer Event, but timer interval is zero
    • Form has timer interval set, but no Timer Event
  • New Suggestions Offered
    • Database should check for truncated number fields
    • OpenQuery is being used to run an Action query, when Execute is better
  • Enhancements to Viewing the Documentation
    • ActiveX controls are displayed along with where they are used
    • Table Fields are displayed in a separate folder under Tables, so you can view, sort and filter all the fields across all the tables
    • Tabs are available for each object type. Their captions are now customized to describe their data. Tabs without data are shown with no caption to make it easier to know when data may exists
  • Report Enhancements
    • Report header, footer, and groupings can be enhanced with your custom color selections and shading
    • Multiple reports can be displayed in preview or report view at once (previously only one report was allowed)
    • New reports
  • New Manual and Context Sensitive Help (coming soon)

For more details, visit new features in Total Access Analyzer 2010.


Important Preview Information

The Total Access Analyzer Preview is designed to provide you with an advance look at the product, as well as the opportunity to submit your requests and needs to the FMS development team before the product is finalized. Keep in mind that the preview is pre-release software. Before downloading and installing the Preview, please be aware of the following:

  • This preview software is not of release quality. Before using this preview on your database, be sure to backup your database.
  • This version only supports the 32-bit version of Access 2010 whether it's on a 32 or 64 bit operating system. We are still working on a 64-bit version. In the meantime, this version will analyze databases created by the 64-bit version of Access 2010 provided it's run from Access 2010, 32-bit.
  • This preview version expires on March 15, 2012.
  • You need to be registered on MyFMS to download the program, and connected to the Internet to activate it.

Downloading and Installing the Preview Software

To install the preview version of Total Access Analyzer, follow these steps:

  1. Download the Preview Version: Total Access Analyzer 2010 (version 14.0)
  2. Run the setup program from your local computer

Free Product Catalog from FMS