Discussion Locked

Couldn't Update-RT Error 3218 Access97

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I get this Run Time error only when the Access MBD file is on the Network and also on another user's workstation. It run OK on my NT4 workstation. It happens when running and sending results (40,000 records) to a table.

5 replies

by dklippert

No solution, but here's the definition of the error:
Error 3218 ?Could not update; currently locked.?
This error occurs when a user tries to save a record that is locked by another user. To handle this error, program your solution to wait for a short period of time, and then try to save the record again. Or, you can display a message that explains the problem and give users the opportunity to try the operation again.

by frankus

Thanks. Based on this answer, I put error trapping for Error 3218 into the code. It sends control back to the update line, which is eventually successful in completing the task.

by donq

Access enjoys both Passive and Sustained record locking. Under your menu options select Tools | Options and select the "Advanced" tab. Make sure Default Open Mode is set to Shared and Defaule Record Locking is set to No Locks.

The database still locks a single page of records during any update but locking is in the Passive mode and the lock is released as soon as the updated record is saved to disk.

This discussion is closed to new replies.