Microsoft Access 2010New Features of Total Access Detective for Microsoft Access 2010, Version 14.0

NOTE: The latest version of Total Access Detective for Microsoft Access 2010 is version 14.5 with these enhancements. Existing customers can upgrade at a discounted price.

The most powerful database, object, module, and text comparison product for Access is now available for Microsoft Access 2010. If you need to know exactly what changed between any two MS Access objects or databases, Total Access Detective is for you.

Microsoft enhanced Microsoft Access 2010 with many new features, a modified ACCDB file format, new properties and commands and a new 64 bit version.

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.

Enhancements

We've made many enhancements compared to the Microsoft Access 2007 version:


Microsoft Access 2010 (32 and 64 bit Versions) and Windows 7 Support

Supports Both 32 and 64 bit Versions of Microsoft Access 2010

Total Access Detective 2010 includes add-ins for the 32 and 64 bit versions of Microsoft Access 2010, and any operating system those versions support including Windows 7, Vista, XP, etc.

Microsoft Access Database Comparison Wizard

Compares All Database Types Supported by Microsoft Access 2010

It supports all the database types used by Microsoft Access 2010 including:

  • ACCDB database formats (Access 2007-2010)
  • Jet Engine/MDB formats (Access 2000, 2002, 2003, and 2007)
  • Access Data Projects (ADP) linked to SQL Server

This means you can use Total Access Detective 2010 with Microsoft Access 2010 to compare databases created by older versions of MS Access.

Compares the New MS Access 2010 Enhancements

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

New Comparison Results

Comparison results are enhanced to let you better understand what changed.

Line-by-Line Comparisons of Embedded Macros

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.

Identical Procedures Listed for Module Comparisons

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.

Indentical Procedures between two Modules


New Documentation Options

The new features give you better control over the comparisons you generate.

New Data Comparison Option to Ignore Case Differences

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.

Compare Data between Microsoft Access Tables and Optionally Ignore Case Differences

When Comparing Modules, Optionally Ignore Blank Lines and Comments

Module and Text Comparison OptionsAdditional 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.

Ignore Blank Lines and Comments for Module Comparisons

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.

Ignore Blank Lines and Comments when Comparing Two Blocks of Text

Similar to module comparison, you can also ignore blank lines and comments when comparing two blocks of text.

Exclude Properties from Comparison

Property Selection Option for Microsoft Access Object ComparisonsYou 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.

Exclude Properties from Microsoft Access Database and Object Comparisons


Create and Manage Multiple Database Comparison Results

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.

Specify Storage Database Name for Database Comparisons

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.

Microsoft Access Database Comparison Storage Name

Specify Storage Folder

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.

Viewing Different Database Comparisons

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.

Select Microsoft Access Two Database Comparison Results Storage File

Command Line Can Specify Storage Database Name

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\Office14\MSACCESS.EXE"
"C:\Total Access Detective 2010\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.


Two Database Comparison Enhancements

Retains Previous 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.

System Tables are Not Selected

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.

Exports Data to another Database

When performing text comparisons in the two database comparison feature, you can now export the results to another database.


New Reports and Report Enhancements

New Reports

New reports are available for:

  • Embedded Macro Differences
  • Embedded Macro Lines
  • Identical Procedures

Reports List is Full Screen with More Information

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.

Microsoft Access Database Comparison Results

Preview Multiple Reports at Once

Multiple reports can now be opened via Preview and/or Report View on separate tabs.


Improved User Experience

General Enhancements

The user interface takes advantage of the new Office/Access 2010 themes to display form and buttons with the new styles.

Manages User Access Control Rights

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.

New Manual and Context Sensitive Help


Pricing and Microsoft Access Versions

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
Licenses Price 2016 2013 2010 2007 2003 2002 2000 97
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

Single $299


More Information

5 Seat $999

Also available as part of

Total Access Ultimate Suite
Total Access Developer Suite

Runtime/Redistributable Version

Not Applicable

Licensing Information

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 Manual and CD

Microsoft Access 2016 Version is shipping!

New Features

New Version 15.5 for
Access 2013

New Version 14.5 for
Access 2010

New Version 12.9 for
Access 2007

Version 11.8 for
Access 2003

Versions 10.7 and 9.7 for
Access 2002 and 2000

Version 8 for
Access 97


View all FMS products for Microsoft Access All Our Microsoft Access Products

Reviews

"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

Readers Choice Award
Best Debugging Tool

Detective Info

Why Detective?

Additional Info

 

 

Free Product Catalog from FMS