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.