Merging Databases

  • Thread starter Thread starter Maria
  • Start date Start date
M

Maria

I have 2 identical access databases, but the tables have
been changed in each database. Is there anyway to merge
these 2 databases?

Thanks,
Maria
 
Sure, but it depends on the changes that have been made.

First have the changes been made to the table structure or the data in
the tables?

Have new records been added to either table?

Is there a primary key field (or one you can make primary) that
identifies each record as unique? Will there be conflicts with this field
from one database to the other?

There are still ways of handling this, but we need to know more
information before suggesting a method.

BTW how many records are there in each table, it may be easier to just
do it manually.
 
Back
Top