Write Conflict

[Penstar]

I have a table where certain records cant be edited. It gives me an error
message "Write Conflict" with options to Save changes (not selectable) Copy
to Clipboard, and Drop Changes. It wont let me delete these records and says
another user was attempting to access data at the same time.

I found a piece of code which when ran indicates to me that I am logged on
three times. I think these are locking the records I need to change.

Can anyone suggest to me how to clear these logon's and access my records?

Penny

 

[Ken Snell \(MVP\)]

Do you have forms open at the same time when you get this error? Do you get
this error when trying to edit data directly in a table, or when you're
using a form? More details, please, about what your setup is and what you're
doing at the time the error occurs.

 

[Penstar]

Thanks Ken

The problem didnt seem to be related to forms. I have since solved the
problem (though I dont understand how it fixed it) by deleting my OBDC Data
Source and setting up a new one (database was linked to SQL server)