Updates for Total Access Analyzer for Access 2000, Version 9.5

This is no longer the latest version of Total Access Analyzer 2000.
Existing 9.X customers can upgrade to Total Access Analyzer 2000, Version 9.8 for a nominal fee.
For more information on the new features, visit Total Access Analyzer 2000, Version 9.8.

The latest update for Total Access Analyzer 2000, version 9.5 is:

9.51.0032 (released December 2006)

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

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 displayed below.

This update includes the following fixes and enhancements:


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

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

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