I recently encountered the following message in Microsoft Access 2003 when attempting to update any column of a linked table (linked to an MSSQL2005 DB):
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.
The interesting part of this story is that there really shouldn't be a write conflict in the data because the linked table in question is in a DB on my local computer which is only being accessed by Access and has no triggers which could be confusing Access. Further investigation, and a useful
thread on Bytes, revealed that the problem was columns in the linked table which have the datatype
BIT and was allowed to be
NULL. Changing the columns to
BIT NOT NULL and refreshing the linked table in Access solved the problem.
Update: KB 280730 covers this issue.
