two attempting to change the same data at the same time. (Error 3197)

[ahvc]

Hello All,
One big database in our office just crashed a week ago. This is the message we get
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time."

There are only 2 users, with one with limited access.

I checked on the help menu. It suggests:
"
The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)
This error can occur in a multiuser environment.

Another user has changed the data you are trying to update. This error can occur when multiple users open a table or create a Recordset and use optimistic locking. Between the time you used the Edit method and the Update method, another user changed the same data.

To overwrite the other user's changes with your own, execute the Update method again.
"
How can I do an 'Update method' when the db will not respond in any way?

Can you please help me. Thanks

AHVC.

 

[AncientOne]

This message means that two people were trying to edit the same set of data at the same time. It doesn't necessarily mean that the edit and update methods were being applied to a recordset, so you can forget that bit if no code was being run.

It really means:

"Do you want to change the record or let the other user do it?"

To avoid this scenario you have to change the RecordLocks property of the form, so that two users cannot simultaneously change the record. See Help under RecordLocks for guidance.

If this error occurred when only one user was logged on, your db may be corrupt. You may need to compact and repair the db to restore it.