Entries tagged as fyi
Thursday, July 23. 2009
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):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
Write ConflictThis 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.
BITand was allowed to be
NULL. Changing the columns to
BIT NOT NULLand refreshing the linked table in Access solved the problem.
Update: KB 280730 covers this issue.
(Page 1 of 1, totaling 1 entries)