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.
Total Access Detective is the most powerful database, object, module, and text comparison product for Microsoft Access. With the release of the version of MS Access 2010, we've released updates for the Microsoft Access 2007 and 2003 versions (versions 12.8 and 11.8 respectively).
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 Microsoft Access 2007 version:
Comparison results are enhanced to let you better understand what changed.
Embedded macros on forms and reports are now compared on a line-by-line basis similar to how regular macros are compared. Previously, the entire embedded macro property was compared without the "smart" comparison that identifies new or deleted lines within the macro code. To support this, the results now have a new Embedded Macros tab when differences exist. For two database comparisons, this is in the Object Differences screen. Three new reports are added to show the differences, and the embedded macro code from each object or database.
In addition to listing the modules lines that are different, a new list of identical procedures is generated. This lets you easily confirm which procedures did not change. The identical procedures are shown on a new Identical Procedures tab after the Module Differences tab. This applies to comparing two objects, two databases, and two blocks of text. A report is provided for printing the list, which can also be exported.
The new features give you better control over the comparisons you generate.
A new option is available to ignore case between fields to perform case insensitive comparisons of your data. This is set under the Data Comparison Options, Field Comparison tab.
Additional options are available to compare modules by ignoring blank lines and comments. This is in addition to ignoring differences due to case or indentations. These options are now available under Text Options.
The Ignore Comments option is a powerful new feature that leverages our VBA Code Parser to identify comments in your code whether they are on their own line, end of a line, or across multiple lines. The result is the ability to identify actual VBA code modifications without clutter from comment changes.
Similar to module comparison, you can also ignore blank lines and comments when comparing two blocks of text.
You now have the ability to exclude properties from the comparisons. For instance, if you donít care about the LastUpdated property of objects, you can exclude it from comparison. This is particularly useful when a property you donít care about is the only difference between objects.
In prior versions, only one set of database comparison results was available. You can now define the name of the database containing the results and save them anywhere.
When comparing two databases, you can now specify the name of the database containing the results. This lets you keep an unlimited number of database comparison results. You can specify the database name on the last page of the wizard. If the name already exists, information on what it contains is displayed.
By default, Total Access Detective saves its files in a user folder. You can now change this location to another folder when you specify the storage folder for the results. When you do that, the storage database is automatically named the same as the first of your two databases.
From the main screen when viewing the results of database comparisons, a new button to open the documentation is available. Easily retrieve a previously saved result. This lets you keep and manage multiple copies of the database comparison results.
Total Access Detective lets you compare two databases using your last selection options from the command line or Windows shortcut.
You can now add an additional parameter specifying the storage database name. This lets you automate the generation of multiple database comparisons. Syntax:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Total Access Detective 2007\tadetect.accdb" /cmd "C:\Northwind1.mdb;C:\Northwind2.mdb; C:\Output\NorthwindCompare.tda"
The first two lines launch Microsoft Access and our database comparison file. The third line is a command which specifies the two databases to compare, followed by the database to contain the results.
Previously, if you were running the two database comparison and selected two databases, the existing results were no longer available, even if you canceled before generating the new comparison. This is now separated so the results are available until you overwrite them.
In the Database Comparison Wizard, if your Navigation Pane has System Objects turned on, the system objects are listed for selection. Previously, all objects were automatically selected for comparison. Now, the system tables are not selected.
When performing text comparisons in the two database comparison feature, you can now export the results to another database.
New reports are available for:
The display of available reports is full screen with a category and description of each report to make it easier to view, understand and select.
Multiple reports can now be opened via Preview and/or Report View on separate tabs.
Total Access Detective respects your Windows login rights. By default, it is installed in your user folder, it updates registry settings in your user section and anticipates the issues around user access control and trusted folders.
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||$69||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$199||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.
"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