Access Write Lock

[Nakul]

Hi,

I am getting the following error when I update records in MSAccess

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.
Copying the changes to the clipboard will let you look at the values the
other user entered, and then paste your changes back in if you decide to
make changes.

[Save Record] [Copy to Clipboard] [Drop Changes] "

I am using SQL server and Linked tables

Any help would be appreciated

Thanks
Nakul

 

[James Goodman]

This can be caused by quite a lot of things. Can you give any more
information about the structure of your db?

On one occaision when I had this error, & was connecting to a SQL DB, it was
because of a trigger firing on the underlying table & modifying the data.
Make sure this is not the case...

 

[Nakul]

No triggers do not exist currently.

I have a bound form with a Query which pulls out single record and the
controls are bound to. The table also has a AutoNumber primary key.

Thnaks
Nakul

 

[Albert D. Kallal]

You have one of several problems:

1) You are running some code that goes and updates the current record.
However, the current record has edits, or needs to be written back to disk.
So, before you run any update code in your form, you want to force a disk
write.

me.Dirty = false.

The above applies to JET, or sql server.

2) You need to expose a timestamp field to the form/code you are using.
ms-access (and many systems) use the timestamp field to figure out
what/when/how to update. So, add a time stamp field.

3) Null bits

Check out:
ACC2000:
Write Conflict Error When You Try to Update Records in a Linked SQL Server
Table

http://support.microsoft.com/?id=280730

 

[Guest]

What do you mean by "expose the timestamp field to Access". I've been having Write Conflict problems with my Access front-end, sql server back-end system despite the fact that my table has a timestamp field. Do I have to make a hidden control on my Access form that is bound to my timestamp field?