Merging copies of the same table

[stepone]

Hello,

Looking for some friendly advice - I have tried searching but have not found the answer to this particular problem.

I created a database for some people recently. They have created a copy of the database, now the two different copies have been updated separately. They want the data 'merged' back into one database.

The one good thing is that each user was updating different columns so in theory the data will not overlap.

I was going to start writing a VBA procedure to do this (although I am not sure how to do it !) but was also wondering if there is a simpler way - perhaps some sort of standard 'merge' facility within access ?

Does anyone have any experience of this sort of problem, or some code that they could share ?

Thanks,
Peter.

 

[Kraj]

I believe you are looking for the Synchronization tool in Tools->Replication.

 

[stepone]

I believe you are looking for the Synchronization tool in Tools->Replication.

Hi there. Thanks for your help, but I don't think I can use replication here - the master database has not been replicated, just copied using Windows Explorer.

Anyway, the master has 11,000 entries in it, and the copy has only 9,000 of these. I want the info for the 9,000 records updated into the master, but I do not want the extra 2000 records deleted. I believe synchronisation would delete the missing records.

I think I am going to have to do this in VBA - if anyone has any advice on how to go about it, it would be greatly appreciated.

Thanks,
Peter.

 

[neileg]

If the key fields match in the master and the copy, you should be able to use an update query to add the dat from the copy to the master.

 

[stepone]

If the key fields match in the master and the copy, you should be able to use an update query to add the dat from the copy to the master.

Thanks Neil - that looks like exactly what I can do.

Cheers,
Pete.