New Features of Total Access Detective for Microsoft Access 2010, Version 14.5

Supports Both 32 and 64 bit Versions of Microsoft Access 2010

Total Access Detective includes add-ins for the 32 and 64 bit versions of Microsoft Access 2010. It supports any operating system those versions support including Windows 10 and 8. The setup program automatically detects which version of Access is installed and installs the appropriate version.

Compares All Database Types Supported by Microsoft Access

It supports all the database types used by Microsoft Access 2010 including:

• ACCDB database formats (Access 2007-2010)
• Jet Engine/MDB formats (Access 2000-2010)
• Access Data Projects (ADP) linked to SQL Server

This means you can use Total Access Detective 2010 with Microsoft Access 2010 to compare databases created by older versions of MS Access. Because Microsoft Access 2013 discontinued support for ADPs, Total Access Detective 2010 is the last Access version that finds differences between ADPs.

Total Access Detective compares module code for differences. Module code may include line numbers to help with error handling to pinpoint exactly which line of code is crashing.

When comparing VBA code, you may have code that’s numbered and not numbered or two modules numbered differently. If you are only interested in the VBA that changed and not the line numbers, Total Access Detective offers a new option to compare your code and ignore any differences with line numbers:

New Option to Exclude Line Numbers

Similar to the search bar on the Microsoft Access navigation pane, Total Access Detective includes a Name Filter to simplify selecting objects when comparing databases:

Name Filter for Selecting Objects

The [Select All] and [Cancel All] buttons work on the filtered list.

Similarly, the Name Filter is also available for Property names in the Property Selection feature:

Name Filter on Property List

After comparing two databases, when viewing the Object Differences, the filter for the object names and properties also has the Name filter.

When comparing two databases, a list of identically named objects is displayed to select them for detailed comparison. Tables are now displayed with information on whether they are linked or not, and a filter is available to easily see the differences:

Select the Tables to Compare

The filter options are:

• All: No Filter
• Local: Both tables are local (exist in their respective database)
• Linked: Both tables are linked to other databases
• Mixed: One is local and the other is linked

When comparing two modules, a new tab shows the procedures with differences. The detail of the differences remains in the main tab, but now there’s a summary list of procedures that are different:

In addition to viewing the data in the tab, corresponding export and reports are available.