Posted by news.sbcglobal.net on 10/26/06 15:30

Hi!

I am able to add records to my SQL 2005 database using bound forms in my
Access application, but if I try to edit any records (not only the new
records I create) using the same bound forms, I receive a write conflict.
For the record, I am currently the only user of this application and my SQL
Server database has only one userID. I used this userID to create all of
the objects in the database and to connect to the database from Access. The
data sources for the bound forms are linked tables, the record source type
is set to "Dynaset" and the record locks are set to "No Locks". "Open
databases using record-level locking" is checked.

The write error says that another user has changed the current record since
it was opened (since I'm currently the only user this isn't possible) and
asks me to copy my changes to the clipboard or drop the changes.

Can anyone suggest what might be causing this? Thanks!

[Back to original message]