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.
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 ninth major release incorporating more features than ever with support for Microsoft Access 2016.
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.
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.
Total Access Detective addresses these issues with a comprehensive, automated tool to reveal all the differences between:
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.
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
Total Access Detective detects differences between any two objects in one database or differences between two databases.
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.
Compare two Microsoft Access databases. Open the Total Access Detective database from the Windows Start menu, and select the two databases to compare.
Extremely detailed analysis is performed to compare a selected pair of objects. The examination is based on the type of object compared:
For more information, visit:
For more information, visit Finding Query Differences
For more information, visit: Finding Form Differences including Code Behind Forms
For more information, visit: Finding Report Differences including their Modules
For more information, visit: Finding Macro Differences
For more information, visit: Finding VBA Module and Procedure Differences
Here are some common situations where Total Access Detective is particularly useful:
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.
Because support for ADPs was discontinued in Access 2013, Total Access Detective 2013 and 2016 support the database formats its version of Access supports without support for ADPs.
If you have an earlier version of Total Access Detective, see the list of enhancements:
A discounted upgrade price is available for existing owners.
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:
Select the Two Objects to Compare in Your Database
Specify the object type to compare from the drop down list:
Select the two object names, and press the [Run] button to perform the comparison.
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:
Example of Form Comparison Differences
When comparing tables, you can find differences in table data as well. This can be based on identical field names or field order:
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:
For modified records, a separate list of each field's pair of values is provided on the Modified Fields tab:
For Modified Records, see the Field by Field Differences
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:
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 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:
For more information, visit: Finding VBA Module and Procedure Differences
Similar comparisons are performed for macros and embedded macros on forms and reports.
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.
The preparation step is very quick and not necessary if you aren't comparing the object types that require this.
To compare two databases, open the Total Access Detective database from the Windows Start menu:
Main Screen for Comparing Microsoft Access Databases
From the Database Comparison Main Menu screen, select the [Generate] button and choose the databases to compare.
Select the two databases then press [Next]:
Specify the Access Databases to Compare
Total Access Detective retrieves a list of identically named objects for you to select for detailed comparisons:
Selecting Among the Identically Named Objects and Get Unmatched 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. If that's all you wanted to get, you're done.
After selecting the objects for comparison, press [Next] to specify the 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.
After pressing [Next], a status screen appears to show if the database was properly prepared to compare some of the objects such as references and command bars:
Confirm the Databases are Prepared for the Analysis
After pressing [Next], you can specify where to store the results. By default, the results are always stored in the same output database path and name. If the database already exists, the information on the database comparison in it is shown.
The file has a TDA extension, but it's actually an unprotected Access MDB database that you can open later if you'd like to get to the raw data. Specify another name to retain database comparison results for multiple pairs of database comparisons:
Specify Where the Microsoft Access Database Comparison Results are Stored
Once you press [Finish], Total Access Detective compares your objects and displays this when completed:
Microsoft Access Database Comparison is Completed
View the results under the [View, Filter & Print] button from the main screen:
View the Microsoft Access Database Comparison Results or Open Previously Generated Results
The results are organized into these categories:
Select Among Summary and Detailed Reports
Here are examples of all the Access comparison reports
Total Access Detective also includes a Text Comparison feature to find differences between any two blocks of text.
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
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.
FMS has a dedicated, professional technical support staff available via phone and email. Support tickets can be created from our Support Site.
Total Access Detective has the following system requirements:
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 2010 version supports all database formats from Access 2000 to 2010 including MDB, ACCDB, and ADPs).
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.
FMS products are available directly from FMS or most corporate resellers. FMS also has international dealers in many countries.
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.
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.
"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