Frequently Asked Questions
Total Access Detective is a Microsoft Access add-in, and is Access
version specific. For example, Total Access Detective 2007 only runs with
Microsoft Access 2007.
Total Access Detective works with databases in any format that is
supported by the specific version of Access. For example, the Access 2007
version supports MDBs from Access 2000 to 2007, ADPs, and the new ACCDB
format. Similarly, Total Access Detective 2003 works with databases in
Access 2000 format or 2002-2003 format, provided that the database is opened
in MS Access 2003.
The following versions of Total Access Detective are available:
Check the
Product Compatibility Chart for version information for all of our
products.
Yes. In addition to
finding
differences between the designs and structures of tables, there is an
option to detect differences between data in two tables. The results are
displayed in a list of new and modified records. For modified records, the
fields which differ and their values are documented. The list can be printed
or exported to your database where you can use it to link to your tables to
retrieve the records. For more info:
Compare
Records (data) Between Microsoft Access Tables and Queries
Yes. After documenting the data differences, there is an option to
combine the data from the two tables. You can specify which table's new and
modified records are kept. The new table is created in your database. For
more info, visit:
Combine Data
from Two Microsoft Access Tables into a New Table
Although there is not a trial version for Total Access
Detective, you can
take the online tour to find out more about this product.
All FMS products come with a 30-day money back guarantee, so you can
buy with confidence!
Registered users of Total Access Detective are automatically notified of
product updates. From time to time, the FMS development team may release
updates of our products. For the latest versions of Total Access Detective,
visit here.
This error indicates that you are trying to compare two databases that
use Workgroup security and you haven't provided your credentials. Total
Access Detective cannot bypass the security system of Access if you don't
have the right to see those objects.
Total Access Detective can compare secured databases if:
- Both databases use the same workgroup security file (*.MDW).
- The user group has open/run permissions for the database (not
necessary for specific objects, just needed at the database level).
Follow these steps to compare two secured databases:
- Open one of the Secured databases using the Workgroup Security file.
- Close the database, but do not exit Access (choose File,
Close Database)
- Open the Total Access Detective database that is used to compare
databases. This is located in the folder where Total Access Detective is
installed:
- For Access 2003 or earlier, it's TADetect.MDB.
- For Access 2007, it's TADetect.ACCDB.
Main Total
Access Detective Page
