FMS Home FMS Software Development Team Blog FMS Facebook Page FMS Twitter
Jump: Search:

Total Access Detective

Detective Info:

Why Detective?

Product 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

More Reviews

Additional Info:

 

 
Find differences between Microsoft Access databases and objects with Total Access DetectiveMicrosoft Access Object and Database ComparisonsDetect differences between Microsoft Access databases, object designs and data with Total Access Detective

Total Access Detective Product Guide

Thank you for your interest in Total Access Detective. FMS is pleased to provide you with this Product Guide to assist in your evaluation of this exciting member of the FMS family of integrated Microsoft Access development products.

Contents

Additional documentation is included with the Total Access Detective product, including a printed User's Guide and full context sensitive help file.


Introducing Total Access Detective

Total Access Detective is the world's leading product for Microsoft Access for knowing exactly what changed between databases and objects. Originally introduced in 1995 for Access 2.0, Total Access Detective is in its seventh major release incorporating more features than ever with support for Microsoft Access 2010.

Total Access Detective is an object comparison wizard. Use it to determine exactly what's different between two objects in one database or identically named objects in two databases.

This is particularly useful when you need to compare two different versions of your database, or databases in multi-developer environments. Every field, control, property, macro line, line of module, code, etc. is compared and differences are shown. There are even options to compare data in tables, permission settings, relationships, and library references.

The Problem

As the most popular database program on the desktop, Microsoft Access databases are used for interactive analysis and a wide variety of sophisticated applications. Over time and as more people or locations are involved, situations arise where it is imperative to know exactly what's different between any two databases or any two objects within a database.

This can include the need to understand what changed between versions, what's different between user and developer copies, changes made by multiple developers, or even the same developer's home/laptop version vs. "official" version.

The large number of things that can change make it extremely difficult to manually determine exactly what changed. Modifications include adding and deleting objects, changing macro and module code, modifying the layout and properties of forms and reports, updating queries, and changing table structure and data.

By not knowing exactly what changed, it is very easy to overwrite another user or developer's changes, undo bug fixes, lose data, or cause enough damage to make an application crash.

The Total Access Detective Solution

Total Access Detective addresses these issues with a comprehensive, automated tool to reveal all the differences between:

  • Any two databases
  • Any two objects in one database

Designed specifically for Microsoft Access, Total Access Detective works directly within Access. To compare two objects in one database, simply open the database and launch Total Access Detective as an Access add-in. To compare two databases, open the Total Access Detective database and point to your two databases. A wizard interface makes it easy to choose the objects and type of comparison to perform.

The results reveal every single difference between the selected objects including properties, controls, code, settings, fields, and even data. Results can be viewed or printed. Quickly and easily understand what changed so you can resolve the differences.

Two time winner of the Access Advisor Reader's Choice Award for "Best Debugging Tool and Testing Tool," Total Access Detective is an important utility for every serious Access user or developer. By knowing the differences, fixes can be quickly implemented, and costly (and painful) overwrites of existing work can be avoided.


Rave Reviews

Here are what some leading Access experts and gurus have to say about Total Access Detective:

"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

"This awesome development tool lets you track differences between database versions…I highly recommend Total Access Detective, particularly if your work involves making changes over a period of time."
Thomas Wagner, Access Advisor product review

"This add-in will save you many hours of difficulty when managing any Access application with multiple developers"
Michael Gunderloy, Smart Access product review


Key Features and Benefits

Total Access Detective detects differences between any two objects in one database or differences between two databases.

Two Object Comparison Overview

Compares any two objects in the same Access database. Simply open your database with the objects to compare, and launch Total Access Detective from the Add-ins menu.

Microsoft Access Addin for Object Difference Detection

  • Compare any two tables, queries, forms, reports, macros, modules, import/export specifications, and table relationships in an Access MDB or ACCDB database, or an Access Data Project (ADP).
  • Combine data from two tables into a new third table in your database
  • Perform a line-by-line comparison on any two blocks of text.

Two Database Comparison Overview

Compare two Microsoft Access databases. Open the Total Access Detective database from the Windows Start menu, and select the two databases to compare.

Microsoft Access Two Database Comparison Program

  • Quick analysis is performed to determine objects that exist in one database but not the other (ideal for flagging new or deleted objects).
  • A list of identically named objects in both databases is presented to be selected for detailed analysis.
  • Detailed analysis is performed on the selected objects, and the results are presented in forms to view on screen or export into a table in your database.
  • A wide range of professionally formatted reports are available for detail and summary information.
  • Combine data from two tables into a new table into your database.
  • Options are available to compare database level information (including security permissions, table relationships, library references, import/export specifications, and database properties).

Object Differences Detected

Extremely detailed analysis is performed to compare a selected pair of objects. The examination is based on the type of object compared:

Tables

  • Structural differences, including new, renamed, or deleted fields
  • Table level properties including linked table settings, description, etc.
  • Changes to field properties, including data type and size, description, validation rules, default values, input masks, etc.
  • Index names, fields, and properties
  • New, modified, or deleted records (for un-keyed tables, the first differing record is listed)
  • Combine data from two tables into a new table

For more information, visit:

Queries

  • Modified SQL strings, query type, parameters, and other properties
  • Query fields and field properties

For more information, visit Finding Query Differences

Forms

  • Form level properties, including record source, filters, rights, views
  • New, modified, and deleted controls
  • Properties of identically named controls and sections
  • Embedded macros
  • Module code behind the forms

For more information, visit: Finding Form Differences including Code Behind Forms

Reports

  • Report level properties, including record source, filters, caption
  • Sections and groupings
  • New, modified, and deleted controls
  • Properties of identically named controls, sections, and groupings
  • Embedded macros
  • Module code behind the reports

For more information, visit: Finding Report Differences including their Modules

Data Access Pages

  • HTML and data source (for MS Access 2003 and earlier versions)

Macros

  • Sub-macros (named macros) in one macro but not the other
  • Line-by-line comparison of command lines including arguments, conditions, and comments
  • Identically named sub-macros:
    Macro comparison is performed using an intelligent comparison algorithm that detects added or deleted blocks of lines, so it doesn't just flag every subsequent line after it encounters the first difference.

For more information, visit: Finding Macro Differences

Modules

  • Procedures in one module but not the other
  • Optionally ignore indentations and/or case
  • Line-by-line comparison for identically named procedures:
    Module comparison is performed using an intelligent comparison algorithm that detects added or deleted blocks of lines. Only the block of code that differs is flagged to make it easy to see what changed.

For more information, visit: Finding VBA Module and Procedure Differences

Command Bars

  • Controls on one command bar but not the other
  • Differences in actions between identically named controls

Common Uses for Total Access Detective

Here are some common situations where Total Access Detective is particularly useful:
  • Multiple developer environments where merging changes to the same database can overwrite someone's work.
  • Deployed applications, where you need to know what an end-user "enhanced" in his/her database. This can include new queries and reports, and changes to data and lookup tables.
  • End-users and power-users who want to know what changed between the current database and an older (backup) database.
  • Modifications made to a database on your laptop (or a copy at home) that need to be applied to the "master" copy in the office.
  • Documentation of all the changes between versions of a database.
  • Documentation of all the changes in a database over a period of time ("this is the work I did over the past week").
  • Examining all differences between a pair of objects (for example, to determine if reports or macros that are basically the same and could be merged into one).
  • Text comparison to verify identical code or blocks of text. This is especially useful for comparing code across different databases, database versions, or other VB/VBA hosts.

Supporting Different Versions of Microsoft Access

Due to the different features and properties in each version of Access, Total Access Detective offers a different version for each version of Access. Each version supports every database format supported by the Access version.

For example, Total Access Detective 2010 supports Access 2010 databases including ACCDB database format (from MS Access 2007 and 2010) and the MDB formats from MS Access 2000, Access 2002-2003, and later. It also compares Access Data Projects (ADPs) created in any Access version.

If you have an earlier version of Total Access Detective, see the list of enhancements:

A discounted upgrade price is available for existing owners.


Compare Two Objects in One Database

From MS Access, open the database with the objects you want to compare, then launch Total Access Detective from the Database Tools, Add-ins menu. The Comparison Wizard appears:

Compare Any Two Objects in Your Microsoft Access Database for Differences
Select the Two Objects to Compare in Your Database

Specify the object type to compare from the drop down list:

Specify an Object Type, then Select the Object Name from the Drop Down Lists

Select the two object names, and press the [Run] button to perform the comparison.

Object Comparison Results

The results of the object comparison are shown in a tabular format that can be printed, previewed, or exported to a table in your database.

This form shows the results of comparing two objects. See the differences at the Form level, and controls that exist in one form, but not the other:

Difference between two Microsoft Access forms showing controls in one but not the other, property and section differences
Example of Form Comparison Differences

Data Differences

When comparing tables, you can find differences in table data as well. This can be based on identical field names or field order:

Find New, Deleted, and Modified Records between Two Microsoft Access Tables
Example of Data Differences Between the Records in Your Tables

This form lists every record that is different between the two tables including new or deleted records. For modified records, the fields that differ and their values are shown. The results are also available on a field by field basis showing the pair of differences:

Field Differences

For modified records, a separate list of each field's pair of values is provided on the Modified Fields tab:

Microsoft Access Table Field Differences
For Modified Records, see the Field by Field Differences

Combine Two Tables into a New One

Total Access Detective even allows you to combine the data from the tables that you compared into a new table with a variety of options:

Options for merging data from two Microsoft Access tables into a new table
Options for Merging Data from Two Tables

Module Differences

For module and macro comparisons, all code differences are shown. Any procedures that exist in one module but not the other are listed. Identically named procedures are compared to each other line by line. Procedures with no differences are listed under Identical Procedures:

Example of Code Differences Between Two Modules in the Same Microsoft Access Database
Example of Differences Between the Modules Behind Two Forms in the Same Database

When comparing modules, there are options to control what differences to ignore. The Ignore Comments feature is particularly powerful if you only want to see actual code changes:

Microsoft Access Module Comparison Options

For more information, visit: Finding VBA Module and Procedure Differences

Macro Differences

Similar comparisons are performed for macros and embedded macros on forms and reports.


Compare Two Databases

To compare two databases, open the Total Access Detective database from the Windows Start menu:

Compare Any Two Objects in Your Microsoft Access Database for Differences
Main Screen for Comparing Microsoft Access Databases

Database Preparation Step

Due to limitations within Access, to compare two ADPs or these objects in an MDB/ACCDB (command bars, library references, and import/export specifications), a preparation step is necessary before comparing databases. To prepare a database, open the database and select Total Access Detective Prepare from the Add-ins menu.

Database Comparison Main Menu

From the Database Comparison Main Menu screen, select the [Generate] button and choose the databases to compare:

Specify the two Microsoft Access Databases to Compare for Differences
Specify the Access Databases to Compare

Press [Next] and Total Access Detective retrieves a list of identically named objects. Select one or all the objects for detailed comparison:

Select Among the Identically Named Objects for More Detailed Comparison
Selecting Among the Identically Named Objects

You can also retrieve a list of objects that exist in one database but not the other under the [Unmatched Objects] button. These are the objects that were added, deleted, or renamed.

After selecting the objects for comparison, press [Next] to specify the comparison options:

Microsoft Access Database Comparison Options
Microsoft Access Database Comparison Options

You can choose whether to compare the records in your table, field properties, library references, security permissions, and module code behind forms and reports. There are also options to specify how the data and modules should be compared, plus the properties to compare if you want to exclude some.

You can then specify where to store the results. You can save multiple database comparison results, each in their own database:

Microsoft Access Database Comparison Results Storage Location
Specify Where the Microsoft Access Database Comparison Results are Stored

A final confirmation screen appears. Press [Finish] to generate the analysis. When it's done, you can view the results under the [View, Filter & Print] button from the main screen:

Microsoft Access Database Comparison Results
View the Microsoft Access Database Comparison Results or Open Previously Generated Results

The results are organized into these categories:

  • Object Differences
    Property, field, and control differences for all the selected objects
  • Data Differences
    Differences in table data
  • Macro Differences
    Differences with macros and sub-macro lines
  • Module Differences
    Differences between modules and procedure code
  • Unmatched Objects
    Objects in one database, but not the other (new, deleted, or renamed objects).
  • Errors
    Objects that could not be opened or analyzed (e.g. locked or corrupt).
  • Print
    A variety of reports that can be previewed, printed, or exported:

Microsoft Access Database Difference Reports
Select Among Summary and Detailed Reports

Here are examples of all the Access comparison reports


Text Comparison

Total Access Detective also includes a Text Comparison feature to find differences between any two blocks of text.

Compare Any Two Blocks of Text as VB6/VBA Modules or Classes for Differences
Compare any Two Blocks of Text as VBA/VB6 Module Code

This is similar to comparing two modules in a database, but this feature does not require the text to be in a module. This is particularly helpful if you are comparing two modules that may have name space conflicts if they were stored in the same database, code that doesn't compile, archived modules on disk, code from Visual Basic 6, etc.

You can compare the text as standard words, or choose to treat it as VBA/VB6 code which tells Total Access Detective to parse and compare the text by procedure name.

For more information, visit VBA Text Comparison


General Information

Product Packaging

Total Access Detective is available by electronic software download. A physical option is also available with CD, on-line help, and a professionally printed user manual.

Technical Support

FMS has a dedicated, professional technical support staff available via phone and email.

System Requirements

Total Access Detective has the following system requirements:

  • Microsoft Access version corresponding to your version of Total Access Detective
  • Any operating system and hardware that supports Access
  • 10 MB free disk space for installation (additional space is needed to store the results)

Versions and Pricing

Due to the unique features of each version of Microsoft Access, a different version of Total Access Detective is available for each Access version. Total Access Detective supports all database formats supported by its version of Access (e.g. the Access 2007 version supports all database formats from Access 2000 to 2007 including MDB, ACCDB, and ADPs).

Total Access Detective is also part of the Total Access Developer Suite and Total Access Ultimate Suite.

Total Access Detective Products
by Microsoft Access Version

Licenses Price 2010 2007 2003 2002 2000 97

Single $199
5 Seat $599

Upgrade Between Access Versions

Single $119
5 Seat $349

Upgrade to Latest Version within the Same Version (X.8 for 2007 and 2003; X.7 prior)

Single $69 N/A N/A
5 Seat $199 N/A N/A

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 developer basis. Each developer who runs the program must have a license. Read the License Agreement for details.

Availability

FMS products are available directly from FMS or most corporate resellers. FMS also has international dealers in many countries.


Conclusion

Microsoft Access databases are used and enhanced everyday. Ultimately, almost all users and developers need to know what changed between copies or two points in time.

Total Access Detective is the only Access database comparison program on the market today. It has won every industry award for its category since its original release for Access 2.0 in 1995. It's truly a godsend when you really need to know what changed between objects or databases. Each Access object has so many properties and design options that it's virtually impossible to manually view and compare all differences between them.

By trying to reconcile changes without an automated tool, you risk losing the time-consuming changes that users or developers have made. With an easy-to-use, interactive interface, Total Access Detective increases the productivity of Access users, and eliminates the headaches associated with reconciling and understanding changes. We think you'll agree it's a must-have tool for every serious Access user and developer.


About FMS

Founded in 1986, FMS is a privately-held, Virginia based firm and the world's leading developer of tools for the Microsoft Access community. With tens of thousands of customers in over 100 countries, FMS customers include 90 of the Fortune 100, all US government departments, plus many other organizations and individual developers.

Known for their quality and power, FMS products are winners of numerous industry awards including every "Best Access Add-in" award since 1994. All FMS products are developed by internal staff and undergo a rigorous quality assurance and beta testing process. Our people include world-recognized experts in the Microsoft Access, Visual Basic, and VBA fields, and Microsoft MVP recipients, Microsoft Certified Professionals, book authors, and speakers at industry conferences throughout the US and Europe.

For more information, visit About FMS.

Total Access Detective is a trademark of FMS Inc. All other trademarks are trademarks of their respective owners.

Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright © FMS, Inc., Vienna, Virginia
Celebrating our 28th Year of Software Excellence