A new version of the most powerful database, object, module, and text comparison product for Microsoft Access 2007 is now available. In conjunction with the new release of Total Access Detective 2016 and 2013, we've created version 12.9 for Access 2007. It replaces version 12.8 that was released when the 2010 version was originally released.
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 version 12.8:
These upgrades were previously released for Total Access Detective 2007:
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||$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 Between Access Versions
|Single||$119||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$349||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Upgrade to Latest within the Same Version
|Update 14.5||Update 12.9||Update 11.8||Update 10.7||Update 9.7|
|Single||$99||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$299||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 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