469,292 Members | 1,310 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,292 developers. It's quick & easy.

ACCESS 97, Pessimistic Record level Locking!???

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
Nov 12 '05 #1
1 3802
Fardude previously wrote:
ACCESS 97, Pessimistic Record Locking!???
Does Access 97 allow record level Pessimistic locking?


Tool>Options>advanced allows you to set record lock options.
So you can set pessimistic locking there, but it will be page level.

Record level locking was not introduced until A2000 and works for
Pessimistic setting (edited record) only.

Regards

Peter Russell
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Anastassios Giannaras | last post: by
8 posts views Thread by Thats Me | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.