I have a database that got copied onto two servers.
Entries were made to both databases. Is there a way to
merge the databases back together and preserve the new
entries?
Yes... BUT. This can be fairly simple, or it can be quite complex,
depending on how the tables are structured and how you combine them.
For one thing, if you have sequential Autonumber fields in any of the
tables, the two databases will have assigned the same autonumber to
*different* records. If you have tables related to this main table,
with Long Integer foreign keys, the duplicate ID's will be propagated
to all the newly added related records. Reassigning the ID's is not
trivial!
In any case, you can use File... Get External Data... Link in one of
the databases to link to the tables in the other database, and write
Append queries to append selected records from the linked table.
Deciding *which* records to append, and in particular deciding how to
handle duplicate ID's, is where this can get to be a bit painful.
