Write Conflict Message on Linked Table

[Kathy Atchley]

I have a table in SQL2000. I link to it in Access2000.
Up until today I've been able to make changes to the table
in both SQL and Access. Today I started getting a Write
Conflict Message when I change a record in Access. The
message says someone else has made a change to the same
record (no one else is using the table at this time). It
has 3 buttons to "save changes" (which is greyed
out), "copy to clipboard" (viewing the clipboard shows the
original record) and "drop changes". As I can't select
the "save changes" button, I can't change the records.
Does anyone have a solution for this?? Any help would be
appreciated. Thanks. kathy

 

[Albert D. Kallal]

There are several reasons for that message.

Often, what happens is you load up a form, the users started editing the
form. You then run some code that updates that SAME RECORD. At this point,
that other person who modified the record is not another person, but is
actually YOUR CODE.

So, if you have any code in the form that uses sql to update the form, then
RIGHT BEFORE you run that code, try a

me.refresh

The above will force a disk write.

The other thing you want to do is make sure the timestamp field on the
sqlserver side is EXPOSED to ms-access. Ms-access will use this timestamp
field to figure out if something have been updated.

Given that the message *just* started appearing out of no where, I would
guess that force a disk write BEFORE you run any update coded should find
things..