Edited by another user..?

[Kent J]

Hi,

I get the odd message when I try to edit a record in a SQL-server table:
'The record is edited by another user....' I know that I'm the only one
editing the record. I have tried to restart Access but been unsuccessful.

What can be wrong?

Kent J.

 

[Wolfgang Kais]

Hello Kent.

Hi,
I get the odd message when I try to edit a record in a SQL-server
table: 'The record is edited by another user....' I know that I'm
the only one editing the record. I have tried to restart Access
but been unsuccessful.
What can be wrong?

Maybe you have opened a recordset in the background and did not
close it before editing the record.
Or you have a form with a subform and have the same record in the
main and subform (sometimes, people do this...).
You can use SQL Profiler to find out what your frontend does.