ACCESS 97, Pessimistic Record Locking!???
Does Access 97 allow record level Pessimistic locking?
In other words, when user A is editing a record (has it locked) and
User B tries to edit it (attempts to lock it), user B will get
an error
saying this record cannot be locked now.
It seems like Access 97 is doing optimistic record level locking. In
above scenario user B, is allowed to edit the record but when tries to
save will get an error that says YOU CAN NOT SAVE BECAUSE THE RECORD
HAS CHANGED!
Is there anyways to change this into pessimistic locking.
Our application is split into two *.mdb s, One that has all of the
Application forms, reports, .... and the other one that has all of
the data.
Thanks for your help in advance.
Fardad
