Simple MDB Merge

Version Beta 0.5

Description:

A Tool for merging tables of identical structure (same fields) from multiple MDB files.

Requirements:

MS Access 97,2000 or 2003 for Microsoft Windows.

Installation:

1. Unzip the contents of the zipfile into a new folder (for instance c:\program files\mdb_merge\)

2. Run the program by clicking on the 'mdb_merge.mde' file.

3. MS Access may come up with a security warning, this is because the application contains VBA code - it wouldn't work without it. Click 'Open' to ignore warning.

Usage:

1. Select folder containing databases. Sub folders will also be scanned. Click on the 'Create Database List' button - the list will now be populated

2. Select the database files to merge. Untick any that you do not want to include. All are ticked

by default.

3. Select common table to merge ('Table to Merge'). This table should appear in each database file

be merged, and each table should be of identical field structure.

4. Click on the 'Merge Checked Databases' button to merge. You can then export merged table to a new/existing mdb. If you choose not to export, the table will reside in the current database.

Troubleshooting:

If you have any merge errors these will be detailed in the Warnings Log (click on 'View Warnings Log'). Errors are usually caused by missing/misnamed tables or differing field structure.

Release History:

03/09/2006 - Version 0.5 Public Bet