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

A2K Record-Level Locking

P: n/a
I'm using A2K and am trying to make sure that my program only locks one
record at a time and I don't seem to have any luck getting that to

In the database options, I've selected "Open Database Using
Record-Level Locking" and the default record lock setting is "Edited
Record". My forms' record lock setting is also "Edited Record".

With the above settings, I get page-level locking. Can pessimistic
locking be used in conjunction with record-level locking?

I use pessimistic locking because I do not like the write conflict
error and I do not want users to waste time editing a record that
someone else has already started editing.

Thank you.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Sorry, I'm using Access 2002, not 2000.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.