New Features of Total Access Detective for Microsoft Access 2016 and 2013

Supports Both 32 and 64 bit Versions of Microsoft Access 2016 and 2013

Total Access Detective includes add-ins for the 32 and 64 bit versions of Microsoft Access 2016 And 2013. It supports any operating system those versions support including Windows 11, 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 2016 and 2013 including:

• ACCDB database formats (Access 2007-2016)
• Jet Engine/MDB formats (Access 2000, 2002, 2003, and 2007)

For older database versions, use Total Access Detective 2010 with Microsoft Access 2010.

MS Access Enhancements with

• New object properties
• New macro syntax and embedded macros on forms and reports
• New VBA module commands

Support for Access Data Projects (ADP) ended with Access 2013, so use Total Access Detective 2010 with Access 2010 to compare 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.