Merging Databases

Hi.

Can someone tell me the easiest way to merge two Access Databases? I have distributed dist.mdb to other employees in my company to edit or add records. dist.mdb consists of one table and eight fields. How can I merge these two databases? If there is another way besides using Access, that would be great, because VB6 is not recognizing Access 2000 databases (I created it in Visdata). Someone please help :-).

Thanks!

David

Do this in a test database - just in case.

Put both copies of the table into one new table (don't set up any indexes/primary key). Make a query - "select distinct * from tablename". This will give you your new recordset to do with as you will.

If there is an autonumber field, don't include it in when you drop the data in the tables - otherwise you may have instances of the following

presuming id is an autonumber field
Table1: id = 1, Name = 'Danny', Job = 'Dreamer'
Table2: id = 99, Name = 'Danny', Job = 'Dreamer'

Both records would be included, in the select distinct, even though what I'm really after is just one copy of 'Danny the Dreamer'. So don't include the autonumber field.

Hopefully, no one is referencing the autonumber (in a mailout, the id is at the top of a mailmerge, people look up records based on the autonumber) - if there is one, otherwise the above solution won't be a good idea. If this is the case, let me know and we'll come up with solution 2.


good luck