merge mdb files - is it easily possible ?
Posted on 2007-10-05
The situation : I'm working with an mdb file describing a database that is rather complicated (multiple tables and references between the tables). At some point in time, a branch happened - ie. two different persons added data to separate copies of the same mdb file. Now, those two versions need to be merged into one mdb file containing all data from both (with no duplicates of course, and no clashing row id's etc.).
The question : can that be done easily, and how ?
I'm sure I don't need to mention that data loss is not an option, so it needs to be a solid procedure ;)
And the size of the database is such that it would be way too much work to copy the data manually.
I will be unavailable for comments in the next few hours (my apologies for that), but will be happy to provide more information if needed when I'm back on-line.