title: Merging Two Access Databases Stored in Different Locations
body: <p>I've searched around for several weeks and I can't find the true answer that I'm looking for. I have two identical Access databases that store file paths. The two databases are stored on two different drives (different locations). I've been trying to find a way to merge the tables without duplicating records. I've incorporated code from the following link: </p>
  
  <p><a href="https://superuser.com/questions/292272/how-do-i-synchronize-multiple-access-databases-together">https://superuser.com/questions/292272/how-do-i-synchronize-multiple-access-databases-together</a>.</p>
  
  <p>The problem occurs when both databases have had added records. The records are added as long as the primary key IDs are not already used. If they are already used it doesn't bother adding the records. Is there a way around this? I can't believe MS Access doesn't have a feature to merge databases. Any help appreciated - thanks</p>