The most powerful database, object, module, and text comparison product for Access is now available for Microsoft Access 2016 and 2013:
If you need to know exactly what changed between any two MS Access objects or databases, Total Access Detective is for you.
We've made many enhancements compared to the Microsoft Access 2007 version:
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 10 and 8. The setup program automatically detects which version of Access is installed and installs the appropriate version.
It supports all the database types used by Microsoft Access 2016 and 2013 including:
This means you can use Total Access Detective 2010 with Microsoft Access 2010 to compare databases created by older versions of MS Access.
Note that support for Access Data Projects (ADP) ended with Access 2013, so that's no longer supported. Use Total Access Detective 2010 with Access 2010 if you need 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:
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:
New Procedures with Differences Tab when Comparing Text
New Procedures with Differences Tab when Comparing Two Modules
New Procedures with Differences Tab when Comparing Modules in Two Databases
In addition to viewing the data in the tab, corresponding export and reports are available.
A new user manual and help file are provided.
Due to the differences within each version of Microsoft Access, Total Access Detective is specific to each version of Access.
Total Access Detective Pricing
by Microsoft Access Version
|Microsoft Access Version|
|Single||$299||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$899||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Upgrade Between Access Versions
|Single||$199||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$599||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Upgrade to Latest within the Same Version
|Update 15.5||Update 14.5||Update 12.9||Update 11.8||Update 10.7||Update 9.7|
|Single||$149||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$449||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Premium Support Subscription
Also available as part of
Total Access Ultimate Suite
Total Access Developer Suite
|Total Access Detective is licensed on a per user basis.
Each user who runs the program must have a license.
Read the License Agreement for details.
New Version 15.5 for
New Version 14.5 for
New Version 12.9 for
Version 11.8 for
Versions 10.7 and 9.7 for
Access 2002 and 2000
Version 8 for
"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
PDF Fact Sheet