Edited by another user..? 1

[Kujen]

Hi,

I get the odd message when I try to edit a record in a linked 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. And also tried to relink the table.

What can be wrong?

Kent J.

 

[PHV]

Does access recognize the PrimaryKey of the linked table ?
No BitField allowing Null in the SQL-server table ?
You may try to add a TimeStamp field in the SQL-server table.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886