Update for Total Access Analyzer for Access 2000, Version 9.5

New 9.8 Version

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

Version 9.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 2000, version 9.5. We encourage you to upgrade to version 9.8.

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

9.51.0032 (released December 4, 2006)

This update is available free of charge to registered owners of Total Access Analyzer 2000, version 9.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.

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 9.5. If you are using Total Access Analyzer version 9.0, click here. If you are using Total Access Analyzer version 9.7, click here.

What's New in Version 9.51.0032

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.

All Fixes and Enhancements from Prior Update Patches

  • This update also includes all issue fixes and enhancements included in prior updates. A version history is displayed below.

Update History

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

Version 9.51.0031


  • 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.


  • 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.

Important Note about MDAC 2.5

If you are using version 2.5 of MDAC and have version 2.5x.xxxx.x of the file msadox.dll, you may encounter an error that is caused by a memory leak in this version of msadox.dll. We recommend updating to ADOX version 2.8 to resolve this issue. The way to obtain this version of ADOX is to download and install the latest version of Microsoft Data Access Components (MDAC) version 2.8 SP1. The MDAC Download can be found here

Also, Microsoft has released additional Service Packs for previous versions of MDAC 2.5 that may resolve this issue in the event you cannot update to MDAC 2.8 SP1. Please try the latest Service pack for the version of msadox.dll you are using (I.E. msadox.dll=2.51.5303.0 tells you that you are using MDAC 2.5 SP1 - as noted in the release manifest). Downloading and installing the latest SP to MDAC version 2.5 may also resolve the issue.

Additional Resources

Patches 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