I have a table we just transferred from MS Access to SQL Server 2016.

It's a simple table for creating load numbers for shipping products. Using access we link to the SQL Server and we are able to add new records and create a load number but we can not edit the record after that. What setting am I missing?

It must be in permissions. Any ideas? I have noticed that I can edit some older records and records that I create so it must be a permissions setting somewhere.

enter image description here


The "Write Conflict" dialog is discussed in the Microsoft documentation for MS Access here:

Write Conflict dialog box

Microsoft Access displays the Write Conflict dialog box when you and another person are attempting to write to the same record in the database at the same time.

That seems pretty straightforward - if other people have access to the SQL Server table (likely), then they have possibly changed the row you're trying to change since the last time results were loaded for you. One way to work around this problem is to periodically refresh your view of the table (for example, after each edit you make).

In practice, there are some caveats to this process with SQL Server specifically around NULL values in the data rows, as well as the presence of a Primary Key and / or Timestamp definition for the rows. These are discussed in this Stack Overflow post:

Editing Record issues in Access / SQL (Write Conflict)

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.