I have multiple Access databases that need to be merged. Each database structure is identical, as all of the databases contain the same table structure and field names. The data was filled with a data entry program that was created using forms inside Access.
However, the database contains 15 tables and the tables are interrelated, so the IDs for each data row need to match up when each database is merged with the others.
So, I need a merge utility, preferably one that can run outside of Access, that adds one database to a master database, because data entry will continue to take place on different computers to different databases, and this task will need to be repeated again and again.
Please ask if you have questions.
## Deliverables
The program should check to make sure a particular database was not already merged (in other words, check to make sure the rows in the database to be merged doesn't already exist in the master database).
There is further work that needs done in the actual Access database data entry program (such as creating a utility that will cascade delete rows), so if the coder wishes to continue working on another project after this one is done, I can post another task for the same coder.
* * *This broadcast message was sent to all bidders on Friday Mar 13, 2009 4:53:03 PM:
Hi, some of you have asked for a sample database to view before making a bid. You can download a blank database from here: [login to view URL] Thanks.