title: MS Access ODBC with PostgreSQL Table Write Conflict
body: <p>So I have to transfer the back end of an Access Database to Postgres recently. After linking the tables to the forms and updating the VBA coding, I tried to create a new record with the primary key field. I verified that this field was created successfully through the back end, but when I try to insert new data into the fields and upon saving the data Access always give me this error.</p>
  
  <p><em>"Write Conflict:this record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made."</em>
  And I am only given two options: Copy to Clipboard and Drop Changes.</p>
  
  <p>The weirdest part is that if I try to open an existing record and modify the fields, I can save successfully. The write conflict error only pops up on the new records that I added.</p>
  
  <p>I tried do some research online, and I had add time stamps to the table and all tables have PKeys. Can anyone explain the reason behind this? Very much appreciated!</p>