Access Data Transfer Assistant 2000 - Copies data between 2 copies of a database for delivery of newer app to customer.

The Access Data Transfer Assistant 2000 rapidly and easily copies data between two copies of a database, either replacing all the data (from specified tables) in one (Destination) from the other (Source), or updating and optionally appending one from the other.

It also provides the ability to rapidly dump all data from all or selected tables. It automatically determines the correct delete and import orders based on the relationships in the Destination database. You can choose to include/exclude any or all tables in the process and cascading deletes are taken into account for excluded tables.

The ADTA documents the record counts for each table before and after the process, as well as all table relationships and fields in both the Source and Destination databases. It also documents the table and field differences between the two databases.

There are other uses for the application too. The ADTA is also a great way to generate numerous append queries that you can import in bulk into another Access database. The ADTA2000 works with Access 97 and 2000 data files and requires Access 2000, 2002, or 2003 to be installed.

Here are some key features of "Access Data Transfer Assistant 2000":

￭ Delete all data from all or selected tables (Dump Data process)
￭ Delete all data from all or selected tables and import all data (where fields match) from corresponding tables in another copy of the database (Copy Data process)
￭ Update all fields in all or selected tables with data (where fields match) from another copy of a database. (Update/Append Data process)
￭ Optionally append all new data (where fields match) from another copy of a database after updating data.
￭ Calculate the correct data deletion and append orders based on existing table relationships.
￭ Delete and recreate table relationships during data processing if required to prevent inadvertent data loss due to cascading deletes being enabled in a relationship.
￭ Build append queries for each selected table
￭ Build update/append or just update queries for each selected table
￭ Only includes tables and fields that are common to both source and destination databases
￭ Document all table relationships in both the Source and Destination databases
￭ Document all tables and fields in both the Source and Destination databases (3 levels of detail)
￭ Provides report for data process summary
￭ Provides reports for table and field differences between the Source and Destination databases
￭ Export all queries to another Access database (or import all ADTA-created queries in bulk from another Access database)
￭ Works with secured databases by providing workgroup information through the Security menu


What's New in This Release:

￭ Fixed startup problem


Limitations:

￭ 20 days trial