469,362 Members | 2,302 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

A2K Record-Level Locking

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
1 1492
Sorry, I'm using Access 2002, not 2000.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.