Total Access Detective for Access 2002

• Introduction
• Technical Details
• Object Comparison
• Database Comparison
• Included Documentation
• Purchasing Information
• Conclusion

---

Introduction

Total Access Detective 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.

---

Technical Details

This section covers the technical aspects of Total Access Detective.

Total Access Detective supports any platform that support Microsoft Access. It has the following system requirements:

• Pentium or better processor.
• 64MB RAM installed (128 MB recommended).
• 10 MB free disk space for installation (additional space is needed to store your documentation).
• Microsoft Access 2002 (XP) (other versions of Total Access Detective are available for Access 2.0, 97, and 2000).
• Screen resolution of 800 x 600 or higher.

---

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).

---

Included Documentation

Total Access Detective comes with the following documentation:

• A complete printed user guide.
• Context-sensitive online help.

---

Purchasing Information

Information on purchasing, pricing, and license terms.

Conclusion

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.