Error in VB "Couldn't save. currently locked by another user."
Posted on 1997-05-04
I've write a multi-user database system using VB4 under Netware 3.12 network (about 40 users).
In this system, all recordsets are opened in shared mode.
Sometimes, the warning message will be displayed when my users want to save or update data into database. This situation is un-predictable.
The error message is "Couldn't save; currently locked by user 'name' on machine 'name'. (Error 3186)".
According the help in VB4, the explaination is :-
"You tried to save a record on a 2K database page that is currently locked by another user. Wait for the other user to finish working with the record, and then try the operation again."
However, I sure that nobody is currently locking the table.
After I restart the program, the problem is the same.
Is it a multiuser JET/Access environment problem in VB ?
If yes, how to solve it ? If no, what's problem and how to solve it ?
Thank you very very much !