I had made a Microsoft Office Access 2007 database with more than 2000 records. A copy of which was given to my friend. We both made a number of amendments and added new records in our respective copies. Now I want to compare both databases & merge the databases into one. There is only one table in the database, so basically both the tables need to be merged with the amendments made by both of us. How do I do it?
Jump to Post
So you have a target database (the one you'll be left with at the end) and a source database, the one you'll copy from. Take a backup of both of your databases before you start.
If you have any unique fields you need to remove them from the source database. …