By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 3,031 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

ACCESS 97, Pessimistic Record level Locking!???

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.