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

Diff between pessimistic lock and optimistic lock

P: 2
Diff between pessimistic lock and optimistic lock
Oct 15 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,366
If you use optimistic locking (No Locks), Access doesn't lock a record or page until a user saves changes to it, and data might be more readily available as a result. If you use pessimistic locking (Edited Records), Access locks the record as soon as a user begins to edit it records might be locked for longer periods of time, but users don't have to decide whose changes to save if two users edit the same record simultaneously.
Oct 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.