New Features of Total Access Detective X.6 for Microsoft Access 2016, 2013 and 2010

The object comparison results shows all the differences between two objects including every property. That can be overwhelming. A new checkbox filters the list to just the major differences:

Filter Table Differences to Just Fields and Indexes in One Table But Not the Other

• Tables: Fields and Indexes in one table and not the other:
  
• Queries: Fields and Parameters in one query and not the other:
  
• Forms: Controls and Sections in one form and not the other:
  
• Reports: Controls, Groups and Sections in one report and not the other:
  

The Database Comparison program is normally launched from a shortcut on the Windows Start menu.

Users sometimes launch Total Access Detective from the add-ins menu intending to do this. The add-in is designed to compare objects in your currently opened database, rather than compare databases.

New Compare Database button on the Total Access Detective Add-in form

The new Compare Databases button launches the Database Comparison program and closes the add-in.

The form for comparing the Two Database Comparison results is simplified and enhanced.

The Overview, Unmatched Objects, and Errors buttons are moved to the top making it easier to understand the overall differences before getting into the details of the Object, Macro, Module and Data Differences. Unnecessary text below each button was removed.

Two Database Comparison Results Form

The Browse button [...] to choose another database comparison is moved to the left from a File Open graphic that was on the far right.

The Overview provides a summary of the differences between the two databases. It adds a tab with a summary of the differences by object type:

Database Comparison Overview Form with Two Summary Tabs

This lets you easily see the types of objects where you have the most differences.

Improved filtering of the differences by Object Type and/or Name to more easily select specific items.

Object Differences

The Object Differences form has a filter on the top with new combo boxes to more easily filter the list by object type and name (if no name is selected, all the differences for the selected type are shown):

Filter Object Differences by Type and Name

---

Macro and Module Differences

Viewing the Macro and Module differences now has combo boxes to choose by object type and name:

Filter Macro and Module Code Differences by Type and Name

Two Object Comparison Swap Button

The Two Object Comparison selection has a new Swap button to flip Objects 1 and 2:

New Swap Button Flips Object Names

The Swap button also refreshes the combo box lists if any objects were added or deleted since the object type was selected

---

When viewing Two Object comparison results, the results were previously in the Objects tab. Now the tab name is the compared object type: Table, Query, Form, Report, Macro, Module, etc.

---

Forms have taller footers and wider buttons. Many button graphics are updated with more modern images and the new Access icon, like the Export button:

Button to Export Data to Your Access Database

---

The Unmatched Objects form shows the two lists with even widths when resized.

A new user manual and help file are provided.

Total Access Detective 2026 is the 10th major release of Total Access Detective since its debut in 1995 for Access 2.0.

Here are the major enhancements for some previous versions:

• Version 16 and 15 for Microsoft Access 2016 and 2013
• Version 14.0 for Microsoft Access 2010
• Version 12.0 for Microsoft Access 2007
• Version 11.7 for Microsoft Access 2003