We have an old Access 97 database that is bringing up the error "Couldn't save; currently locked by user 'Admin' on
> machine '******'. (Error 3186)."
This occurs when two users are in the same form (a subform, actually) and the one user tries to exit after having entered a new record.
The database is set as muli-user and I have the Default Record Locking set to "Edited Record" (it had been set to "No Locks" previously--the error occurs on either setting). Other settings seem OK.
I've done some research and tried different things but to no avail.
Any ideas?
Thanks!
Paul
> machine '******'. (Error 3186)."
This occurs when two users are in the same form (a subform, actually) and the one user tries to exit after having entered a new record.
The database is set as muli-user and I have the Default Record Locking set to "Edited Record" (it had been set to "No Locks" previously--the error occurs on either setting). Other settings seem OK.
I've done some research and tried different things but to no avail.
Any ideas?
Thanks!
Paul