Merging Databases

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
 
J

Joseph Meehan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top