Updates for Total Access Detective 2000, Version 9.0

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

The latest update for Total Access Detective 2000, version 9.0 is:

9.02.0017 (Released September 28, 2005)

This update is available free of charge to registered owners of Total Access Detective 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.

In addition to this update patch, we have released a major update for Total Access Detective 2000. Version 9.5 is available to current Total Access Detective owners for a small upgrade fee, and introduces many new features and enhancements, including:

Object and Database Comparison

  • When viewing data comparison results, you can now combine the data into a new table and specify which table’s records to retrieve.
  • Data Comparison results can be filtered by difference type to show only a subset of data.

Database Comparison

  • Access Data Projects (ADP and ADE files) can be compared.

Report Enhancements

These new reports are available:

  1. Database Comparison Summary: Provides an overview of the difference between two databases.
  2. Data Differences Summary: For each keyed table with data differences, shows the number of new vs. modified records, and a list of non-keyed tables with data differences.

To learn more about the latest version of Total Access Detective, visit the main Total Access Detective web page.

Update History

Version 9.02.0017 includes the fixes and enhancements made in prior updates for the product.

  • Resolves all known issues in previous versions of the product.
  • Includes a new report to show a list of selected objects.
  • Has improved performance for comparison of linked tables.

Important Note about Comparing Linked Tables

When comparing table properties for linked tables, Total Access Detective compares the tables in the back end database (where the tables are linked from) rather than in the front end database (where Detective is running). This significantly increases performance, however if the field properties have been changed in the front end database, Total Access Detective will not detect these differences.

This update includes the following enhancements and fixes:

Object and Database Comparison

  • Total Access Detective finds differences in Conditional Formatting properties. Conditional formatting allows you to format the contents of a control in a form or report based on one or more conditions.
  • Total Access Detective finds differences in capitalization in table data and in object properties.
  • Updated help file is provided.
  • Object comparison results can be exported to a table in a separate database.

Database Comparison

  • Object Difference comparison results can be filtered by object and property.
  • Previous versions of Total Access Detective did not support comparison of password-protected databases. This version supports comparison of tables, queries, modules, and data access pages, along with database level items like references and relationships in databases protected by a password.
  • You can now compare identically named databases in the same directory with file extensions for database preparation files different for MDB and MDE databases. The new extensions are DDB and DDE respectively.
  • During object selection, Relations are listed as a separate object that can be included in or excluded from comparison. 

Report Enhancements

  • These new reports are available:
  1. Objects with Differences: Shows objects along with their number of properties and code differences that were detected.
  2. Identical Objects in Both Databases: This report shows objects selected for comparison without differences.
  • Previous versions showed a separate Data Differences report for each pair of tables. This version consolidates Data Differences data into one report.
  • The Data Differences reports show new/modified records for keyed tables, or the first changed record between non-keyed tables.
  • Report headers display the date and time that the comparison was created (previous versions showed the date and time that the report was printed).
  • Report footers display "Page N of M."

This update includes the following enhancements and fixes:

Overall Application

  • Eliminated licensing conflicts in certain international languages settings.
  • Performance improvements for non-replicated databases.
  • When comparing table properties, GUIDS and NameMap properties are no longer compared, since differences in these objects do not affect your database. This improves performance, and makes it easier to view important differences between table properties.
  • Report footers are enhanced with a border, making them easier to read.
  • Table comparison of tables with multiple field Primary Keys are correctly handled if one of the fields has a null value.
  • Problems with Data Differences report have been resolved.

Database Comparison

  • Total Access Detective always opens using the correct version of Microsoft Access. This is accomplished using Total Access Startup, also available from FMS.
  • Supports databases containing the . or ! character.
  • Report menu enhanced with Select All and Clear All buttons.
  • New report called "Objects in both databases with differences" shows the objects with differences, and the number of differences in each.
  • Problems with "Objects with Differences" report resolved.
  • Long database paths are shown without truncating them in report headers.
  • While viewing object differences, filter problems are resolved.
  • Microsoft Access closes after you close Total Access Detective.

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.

Total Access Detective Manual and CD

Microsoft Access 2016 Version is shipping!

New Features

New Version 15.5 for
Access 2013

New Version 14.5 for
Access 2010

New Version 12.9 for
Access 2007

Version 11.8 for
Access 2003

Versions 10.7 and 9.7 for
Access 2002 and 2000

Version 8 for
Access 97

View all FMS products for Microsoft Access All Our Microsoft Access Products


"Total Access Detective is well worth every penny, it will quickly pay for itself through savings in time and effort."

Tom Cryan, Denver Access User Group product review

Readers Choice Award
Best Debugging Tool

Detective Info

Why Detective?

Additional Info



Free Product Catalog from FMS