NOTE: The latest version of Total Access Detective for Microsoft Access 2007 is version 12.9 with these enhancements. Existing customers can upgrade at a discounted price.
The most powerful database, object, code, and text comparison product for Access is now available for Microsoft Office Access 2007. If you need to know exactly what changed between any two Access objects or databases, Total Access Detective is for you.
Microsoft made a big investment to create Access 2007 and added a lot of great new features with significant changes to objects, properties, VBA code, the user interface, embedded macros, and an entirely new database format with new field types.
Total Access Detective supports these new features with additional enhancements to extend its functionality and simplify its use based on our experiences and customer feedback.
We've made many enhancements compared to the Access 2003 version:
Total Access Detective 2007 supports all the database types used by Microsoft Access 2007 including:
Completely redesigned user interface to support the sleeker Office/Access 2007, Vista/XP color schemes, and look and feel. The user interface takes advantage of the new features such as:
Main Menu for Two Database Comparison
Many enhancements were made for comparing ADPs objects.
New features let you better control the comparisons you generate.
For module comparisons, in addition to ignoring indentations, you can now Ignore Case. This lets you avoid flagging differences due to mismatched capital and lower case letters.
This option is also available for the Text Comparison feature.
More information on Comparing Microsoft Access Modules and Text
When comparing two tables, you can compare either the table design or data, or both. Previously, the design was always compared.
The text comparison feature which was previously only available under the two object comparison add-in, is now available on the two database comparison side as well.
Previously, data could only compared if the two tables had identical field definitions. There are now several options to compare tables:
Data from two queries can now be compared with an option to specify whether to perform a sequential search or use the first field as a key field.
Specify whether you want to see all numeric differences, or differences that exceed a certain percentage. This lets you avoid small rounding errors and immaterial differences.
Previously, during data comparison, modified records were only displayed as individual records listing all the modified fields in one record. This is now supplemented with an additional table listing each field difference as a separate record showing the two values.
More information: Comparing Data in Microsoft Access Tables and Queries
Screen flashing is eliminated when comparing forms, reports, and modules. This lets you minimize Total Access Detective while itís processing.
Previously, once you closed the results of your comparison, your analysis was gone. Now, a Last Analysis button retrieves the results. This is preserved even if you close the Total Access Detective add-in and return (provided your database remains the same).
Last Analysis is Available from the Add-in for Comparing Two Objects
Similarly, the last selected object names are preserved when you run Total Access Detective again.
If you cancel while the objects are being compared, the process stops and the incomplete results displayed rather than discarded.
This can be particularly helpful when comparing data and you decide to stop after it identifies a few differences and donít need all the differences.
Object and other differences (data or modules behind forms/reports) are now shown on separate tabs:
Previously, the Total Access Detective Prepare step was necessary before comparing modules between two databases. This is no longer needed when comparing MDB/ACCDB databases. Prepare is still required for ADPs.
The Database Comparison wizard now has a Finish button on all its pages. Simply select the two databases and press Finish to compare all the identically names objects. It skips the subsequent Wizard pages, and uses the previously specified values.
To eliminate manually selecting the database and options, a Windows shortcut can pass the names of the two databases to compare. It then compares all the common objects in the two databases using your last settings.
Objects in password protected databases are compared.
Many new reports were added:
Several reports were enhanced including:
Two Database Comparison: Report Selection Screen
Individual or multiple reports can be exported to a folder you specify in formats such as Adobe PDF, HTML, Snapshot, Text, RTF, or XPS.
Many other improvements and performance enhancements were implemented to make Total Access Detective better than ever! There's also a new 87 page, professionally printed user manual.
For a quick overview of Total Access Detective 2007, Take the Tour.
Due to differences with 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