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

A new version of the most powerful database, object, module, and text comparison product for Microsoft Access 2010 is now available. In conjunction with the new release of Total Access Detective 2016 and 2013, we've created version 14.5 for Access 2010.

If you need to know exactly what changed between any two MS Access objects or databases, Total Access Detective is for you.

Previous Version

The version previously released for Total Access Detective 2010:

Version 14.5 Enhancements


Supports Both 32 and 64 bit Versions of Microsoft Access 2010

Total Access Detective includes add-ins for the 32 and 64 bit versions of Microsoft Access 2010. 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.

Microsoft Access Database Comparison for What Changed

Compares All Database Types Supported by Microsoft Access

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

  • ACCDB database formats (Access 2007-2010)
  • Jet Engine/MDB formats (Access 2000-2010)
  • 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. Because Microsoft Access 2013 discontinued support for ADPs, Total Access Detective 2010 is the last Access version that finds differences between 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:

Ignore Line Numbers when Comparing Modules for Differences
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
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
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:

Filter Tables based on Whether it's Linked
Select the Tables to Compare

The filter options are:

Table filter Options

  • All: No Filter
  • Local: Both tables are local (exist in their respective database)
  • Linked: Both tables are linked to other databases
  • Mixed: One is local and the other is linked

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 Text

New Procedures with Differences Tab when Comparing Two Modules
New Procedures with Differences Tab when Comparing Two Modules

New Procedures with Differences Tab when Comparing Modules in Two Databases
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.


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