By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,471 Members | 722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,471 IT Pros & Developers. It's quick & easy.

SQL 2005: Unable to edit linked table records

P: n/a
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!
Oct 26 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
news.sbcglobal.net wrote:
Can anyone suggest what might be causing this?
1) Lack of a primary key.
2) Lack of a timestamp column.

Every table in a SQL Server database should have these if you're linking from
Access.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1

Oct 26 '06 #2

P: n/a

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

Oct 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.