Posted by Greg D. Moore \(Strider\) on 10/27/06 03:13

"news.sbcglobal.net" <groomeryNOSPAM@MAPSONsbcglobal.net> wrote in message
news:7w40h.262$wX.134@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!
>

[Back to original message]