Access Data Transfer Assistant 2000 3.3

Access Data Transfer Assistant 2000 3.3 Screenshot 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.

Developer:   Custom Business Applications Corporation
      software by Custom Business Applications Corporation →
Price:  59.00  buy →
License:   Trial
File size:   0K
Language:   
OS:   Windows Vista (?)
Rating:   0 /5 (0 votes)

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.

Access Data Transfer Assistant 2000 features
  • 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

    tags destination databases  and destination  source and  data process  the source  table relationships  all data  selected tables  data from  for each  data where  and fields  both the  

    Access Data Transfer Assistant 2000 3.3 screenshot


    Download Access Data Transfer Assistant 2000 3.3

     Download Access Data Transfer Assistant 2000 3.3

    Purchase:  Buy Access Data Transfer Assistant 2000 3.3


    Authors software

    Access Data Transfer Assistant 2000 3.3 Access Data Transfer Assistant 2000 3.3
    Custom Business Applications Corporation

    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.

    Access Data Transfer Assistant 2003 3.3 Access Data Transfer Assistant 2003 3.3
    Custom Business Applications Corporation

    The Access Data Transfer Assistant 2003 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.

    Similar software

    Access Data Transfer Assistant 2000 3.3 Access Data Transfer Assistant 2000 3.3
    Custom Business Applications Corporation

    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.

    Access Data Transfer Assistant 2003 3.3 Access Data Transfer Assistant 2003 3.3
    Custom Business Applications Corporation

    The Access Data Transfer Assistant 2003 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.

    Access-MySql 2.5 Access-MySql 2.5
    softgalaxy

    Access-MySQL is an effective tool for data conversion from MS Access databases to MySQL server and vice versa, supporting many advanced features like, the ability to select certain number of tables from the source database and moreover there is an ability to select certain number of fields from each table, converting relationships between tables, command line support, and scheduling of the conversion tasks to be performed automatically.

    MySQL Data Wizard 6.7 MySQL Data Wizard 6.7
    SQL Maestro Group

    MySQL Data Wizard is a powerful tool for managing your MySQL data.

    AccessDiff 5.0.0 AccessDiff 5.0.0
    Kellerman Software

    AccessDiff will compare objects with the same name between two databases.

    Ezy Data 2000 4.2.1 Ezy Data 2000 4.2.1
    aadconsulting.com

    Ezy Data 2000 lets you easily create relational databases of tables and queries for entering, storing, viewing and analysing data.

    EMS Data Pump 2006 for DB2 2.2 EMS Data Pump 2006 for DB2 2.2
    EMS Software Development

    EMS Data Pump for DB2 is a useful and powerful utility for converting databases and importing table data from an ADO-compatible source (e.

    EMS Data Pump 2006 for MySQL 2.1.0.5 EMS Data Pump 2006 for MySQL 2.1.0.5
    EMS Software Development

    EMS Data Pump for MySQL is a useful and excellent utility for converting databases and importing table data from an ADO-compatible source (e.

    DBPut data transfer 3.1.241 DBPut data transfer 3.1.241
    dbput

    DBPut data transfer is a great db transformer for multiple types of databases.

    EMS Data Pump 2006 for PostgreSQL 2.2.0.2 EMS Data Pump 2006 for PostgreSQL 2.2.0.2
    EMS Software Development

    EMS Data Pump for PostgreSQL is a powerful and excellent utility for converting databases and importing table data from an ADO-compatible source (e.

    Other software in this category

    kaztrix DataBuilder 1.0 kaztrix DataBuilder 1.0
    Kaztrix Software

    KazTrix DataBuilder 1.

    ConversionTool 4.2.2 ConversionTool 4.2.2
    Keper Consultancy

    The conversiontool is a tool which easily converts a MS Access database to a SQL Server database.

    SQLClean 2.3.76 SQLClean 2.3.76
    Lockwood Technical Services, I

    If database object bloat is the problem, SQLClean is the solution.

    XL Report Builder 2.1.4 XL Report Builder 2.1.4
    Desktop Software

    Knowledge is Power.

    DB Navigator 3.0.0 DB Navigator 3.0.0
    Desktop Software

    DB Navigator is an application for the work with database tables of the DBF format.