Home Contact Us Consulting

About Us
Download Demos
Business Products
Developer Tools
Developer Partners / Resellers
Third Party Software
Training Courses
Related Links
Special Upgrade Offer


Azalea Barcode Font
PC Charge
Pendragon Forms
Speed Ferret
Total Access Admin
Total Access Memo
Total Access Analyzer
Total Access Components
Total Access Detective
Total Access Emailer
Total Access Speller
Total Access Startup
Total Access Statistics
Total Visual Agent
Total Visual CodeTools
Total Vis. SourceBook
Total Ultimate Suite
Total Developer Suite
Total Visual Developer Suite
Total SQL Analyzer
Calendar Tools 3.0



Technical Support
Custom Programming
Data Conversion


Business! Certified Partners can help you purchase, install, and setup our products. Many also provide support, training and custom programming services.

Learn more about the Business Certified Partner program

Find a Business Certified Partner

Total Access Detective


Total Access Detective, by FMS Inc., is the premier database and object comparison tool for Microsoft Access. Use it to determine exactly what is different between two objects in one database or between two databases.

This is particularly useful when you need to compare two different versions of your database, or databases in multi-developer environments. Total Access Detective compares every field, control, property, line of code, etc., and shows you the differences. There are even options to compare table data and permission settings.


If youíre managing databases in multi-developer or multi-user environments, Total Access Detective is the only tool you'll ever need. Fast, efficient and powerful, Total Access Detective provides full support for Access objects as well as data comparison in tables, and gives you a complete set of reports.  We think youíll agree itís a must-have tool that every developer should own.

What Total Access Detective Finds

  • Differences between two objects in one database, including properties, lines of code, and even data between tables.

  • Differences between two databases with detail difference comparison among similarly named objects and lists of objects in one database and not the other

When Total Access Detective Is Needed

When you need to know exactly what changed, Total Access Detective delivers! For example:

  • Documenting differences between an older version and the current version of your database. Great for listing all the work you did for your client or boss!

  • Modifications made by your users to a deployed database. Great for understanding new and modified queries and reports. Important if your users claim they didn't change anything.

  • Data changes made to your version or a client's version of a database. Great for detecting new or modified data, changes to lookup tables, etc.

  • You worked on the database at home, came back to the office and forgot to update the office version before making new modifications. It's awfully nice to be able to reconcile and save all your effort. Missing one item could cause a bug that haunts you later!

Object Comparison

The Total Access Detective Object Comparison feature compares two objects in the same database. Simply open your database with the objects to compare, and launch Total Access Detective from the Add-ins menu.

  • Compare any two tables, queries, forms, reports, data access pages, macros, modules, or command bars in an Access MDB database.
  • Compare any two Access objects such as forms, reports, data access pages, macros, modules, and command bars in an Access Data Project (ADP).
  • Perform a line-by-line comparison on any two blocks of text.

Database Comparison

Total Access Detective also allows you to compare two databases using the Database Comparison feature. Open the Total Access Detective database from the Windows Start menu, and select the two databases to compare.

  • 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 all the selected objects, and the results are presented in forms that can be viewed on screen or in professionally formatted reports.

  • Options are available to compare database level information (including security permissions, table relationships, and database properties).

New Features in 2002

  • Supports Access 2002 databases, including all new Access 2002 properties

  • Uses an improved parser to document your objects much faster

  • Includes new reports for Macro and Module differences

Save Time: Guaranteed!
Total Access Detective is invaluable when you need to know the exact difference between your objects and databases. Use it for 30 days and if it doesn't pay for itself, return it for a prompt and courteous refund.



Total Access Detective for Access - Single



Total Access Detective for Access - 5 Users   $595



Total Access Detective:

  • Works Access 2002, 2000, or 97

  • Compare 2 databases to quickly discover changes

  • Context sensitive help and user guide included


System Requirements:

  • Pentium processor or better

  • Windows 98, 2000, ME, or NT 4.0

  • 64 MB RAM (128 recommended)

  • 10 MB available hard disk space

  • Access 2002, 2000, or 97

  • Screen Resolution 600x800 or higher

Back Home Up Next

Database Creations
Sales: 800-277-3117 - Support: 860-644-5891
Fax: 800-277-3117 - Email: sales@databasecreations.com

©2012 Database Creations LLC. All Rights Reserved. Privacy Statement