Update for Total Access Analyzer for Access 2002, Version 10.0

New 10.8 Version

The current version of Total Access Analyzer 2002 is version 10.8, which includes many new features and enhancements.

Version 10.8 is available for free to premium support subscribers. Non-subscribers can upgrade here.

More details...

FMS no longer provides new updates for Total Access Analyzer 2002, version 10.0. We encourage you to upgrade to version 10.8.

For those who do not upgrade to version 10.7, this patch is available:

10.01.0032 (released November 16, 2006)

This update is available free of charge to registered owners of Total Access Analyzer 2002, version 10.0. The existing version must already be installed.

Notification and download instructions for receiving the patch were emailed to registered owners. If you did not receive instructions, please contact us so we can update your information.

Note that this update only applies to users with Total Access Analyzer version 10.0. If you are using Total Access Analyzer version 10.5, click here. If you are using Total Access Analyzer version 10.7, click here.

Update History

This update includes the following fixes and enhancements:

  • Report Blueprints can be properly generated for Mailing Label reports.
  • The "Query List Action Queries" reports properly show all Action queries.
  • This update also includes all issue fixes and enhancements included in prior updates. A version history is included below.

This update includes issue fixes from all previous updates, including:


  • Documentation runs faster and more efficiently than ever.
  • A new "Suggestion Box" link on the Main Menu allows you to send product suggestions directly to our development team.
  • While objects are being loaded for documentation, a Cancel button allows you to cancel the process.
  • Issue Filter form displays only issues that exist in the current documentation results.
  • Several forms throughout the application can be resized to show more information, including the Reports menu, Search results, and Report Thumbnails. Total Access Analyzer also "remembers" your size preference for these forms, and uses it in the future.
  • Various UI enhancements have been made to improve the appearance and usability of the application.


  • After documentation is complete, the Documentation Summary form displays a count of issues by object type.
  • Improved documentation of CommandBar controls.
  • Improved documentation of Hyperlink and Subhyperlink addresses.
  • Improved documentation of VBA Function Calls for function calls on macro lines.
  • Improved cross-reference documentation for subforms and subreports.

Documentation Explorer

  • Boolean property values are displayed as Yes/No instead of as -1/0.


  • On the Report Options form, a new feature allows you to reset all options to their default values.
  • The Hyperlink report (under Object XRef) now contains a check box to show code references to a hyperlink address thatís a variable or constant.
  • The Blueprint Detail report displays the source object name for subform/subreport controls.

This update includes the following fixes and enhancements:


  • Documents only the Access Options that apply to the database type: MDB or ADP.
  • Documents text values instead of numeric values in several places (e.g. for documentation of colors and languages).

Documentation Explorer

  • Includes right-click filter options when viewing Errors, Suggestions, and Performance Tips.
  • Issue Filter form displays only issues that exist in the current documentation results.


  • "Form Hotkey" report is named "Form Shortcut Key" to reflect Microsoft's change in terminology.
  • The "Total Access Analyzer Report List" report displays only a list of reports that apply to the database type: MDB or ADP.
  • Includes a new report to show Access Options grouped by tab.

New Error Detection

  • Detects functions that do not return a value.
  • Detects property Get statements that don't return a value.

This update includes the following fixes and enhancements:

  • The "New Values" field property for Autonumber fields ("Increment" or "Random") is documented.
  • For MDBs and MDEs, table documentation includes an estimate of table size. This information appears a new Table List Report, as well in reports that show table record counts.
  • The Table Index Properties report displays the index field names along with its properties.
  • For forms and reports without a RecordSource, previous versions of Total Access Analyzer listed separate errors for every bound control. This version consolidates these errors into one error, which notes that the form or report has no RecordSource, and lists the number of bound controls.
  • Relationship errors due to invalid fields, foreign table fields, and foreign tables are flagged separately. Previous versions of Total Access Analyzer listed one generic error for the relationship.
  • Table and query names that contain characters that conflict with SQL Server.

Additional Resources

Updates are for registered users only and subject to the product licensing terms.
You may not re-distribute them without express written permission from FMS, Inc.

Free Product Catalog from FMS