Why Use Total Access Detective?

Are you using Microsoft Access? Having trouble keeping track of different versions of objects and databases? Do you have multiple copies of a database that you need to keep in sync? Did you or someone else make fixes in one version and can't remember all the changes?

Discover how Total Access Detective will make your life easier by providing comparison tools for Microsoft Access databases and objects.

• Why do I need Total Access Detective?
• What else can Total Access Detective do for me?
• What are the product's features?
• How do I run Total Access Detective?
• I need a solution that is simple and quick!

Why do I need Total Access Detective?

Access database development takes time and effort. Losing changes or not realizing what has changed can cost you considerable time, money, and headaches. Here are some examples of how people use Total Access Detective to simplify their development efforts.

Total Access Detective finds:

• Discrepancies in your database at the office and the one you worked on at home or on your laptop.

• Differences in an older version and the current version of your database. 
  Great for documenting 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.

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

What else can Total Access Detective do for me?

Total Access Detective is also useful for:

• Resolving modifications by multiple developers. 
  Know exactly which objects were modified and how!

• Comparing module code between multiple versions of Access with the Text Comparison feature.

• Knowing which objects exist in one database and not the other.

Stop overwriting someone else's work or your own! Pinpoint every change that was made, and update your databases with confidence!

What are the product's features?

Compare Any Two Objects in One Database

• Table fields, indexes, and properties

• Query fields, parameters, and properties
• Form and report properties, controls, and module code
• Macro lines
• Module code (smart comparison that compares procedures even if they are reordered)
• Data Access Page (DAP) HTML and data source
• Access objects in an ADP

Compare Any Two Databases

• Compare MDBs or ADPs
• Quickly list modified (identically named) objects
• Determine objects in one database, but not the other
• Select objects for detailed comparisons
• Compare table relationships
• Compare object permissions

Compare Data between Tables

• Detect new and deleted records.
• Detect modified records and field differences.
• Combine data into a new table and specify which table's records to retrieve.

Text Comparison

• Perform line-by-line comparison of any two blocks of text.
• Perform intelligent text comparison of any two blocks of module/class code, so that adding, deleting or sorting procedures still compares procedure lines to itself

How do I run Total Access Detective?

Total Access Detective is implemented as an easy-to-use Wizard. It runs within Microsoft Access and stores its results in tables in its own database. The product includes customizable reports, extensive on-line help, and a comprehensive user manual. Total Access Detective works in two modes:

Compare Two Objects in One Access Database

Open your database with the objects to compare and launch Total Access Detective from the Add-ins menu. The Comparison Wizard lets you select the objects to compare and presents the detailed results. You can also use the text comparison feature to compare any two blocks of text.

Compare Two Microsoft Access Databases

Open the Total Access Detective database and select the two databases to compare. A quick analysis determines the list of objects in one database and not the other, and presents a list of identically named objects. You can choose some or all of the identically named objects for detailed analysis.

All results can be viewed and printed. Reports include lists of differences, complete source code printouts for macros and modules, and more.

I need a solution that is simple and quick

The last thing you have time for is manually comparing hundreds of objects and thousands of properties across objects and databases. You need a solution that takes no time on your part. Total Access Detective uses step-by-step wizards to take the work out of comparing objects and databases. When the analysis is complete, all you need to do is view and print/preview the results.

The results are in Access tables, which you can copy or export.