Merge two Access databases with some quirks
Posted on 2014-07-22
Hello, so I have this customer who made quite a mess out of his Access database.
Two versions of the same database have been worked on, so that one version has more records than the other, but the other version has many corrections on common records.
So there's a table with records for july, and the other table with no july records but more up to date records up to june.
Moreover, tables have usually correlated records in other tables.
So, if I want to keep the up to date records and add the new records, how would I proceed? Keep in mind I'm a TOTAL Access newbie.