SQL 2005: Unable to edit linked table records

[news.sbcglobal.net]

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!

[Greg D. Moore \(Strider\)]

"news.sbcglobal.net" <gr************@MAPSONsbcglobal.netwrote in message
news:7w**************@newssvr12.news.prodigy.com.. .

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.

Make sure all tables have indexes on them.

>
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!