The ADTA can also be used to maintain a central master database, updating and/or appending data from remote databases.

ADTA features include:

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 (except autonumber primary keys) 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. NEW

Document all table relationships

Document all tables and fields

Reports for table relationships and data process summary

Reports for tables and fields (3 reports with varying levels of detail), and a data dictionary

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

Easily document your database. The ADTA produces six reports.

Providing complete relationship documentation, the Relationships report lists all relationships with their tables, foreign tables, fields, foreign fields, relationship name, attributes (long integer) and each of the seven components of the attributes property of the relationship object.
The Summary Report includes the start and finish date and time and the elapsed time; destination and source paths and files; deleted relationships; recreated relationships; relationships deleted that could not be recreated (haven’t had this happen yet); and a list of all the linked Destination tables, whether or not they participated in the process, their record counts before and after the process, and the record count difference.
Three reports documenting tables and fields are available with varying levels of detail.
The Data Dictionary report provides a listing of a fields, the tables they are in, and the description you entered for each field.