Liz-
Default Record Locking should be No Locks. Note that applies only to new forms you design. Open Database Using Record Level Locking should be checked - that minimizes the chance that Access will lock an entire page when it does need to lock.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Thursday, September 19, 2013 3:13 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] record locking
Thanks John, and from such an expert! I am so fortunate to have you in my life.
Hey, so when I look at the "options / advanced" section of the database I see 2 different switches… radio buttons for default record locking: one that has the default record locking (set at edited record) and another checkbox that says open databases by using record level locking. I don't understand this distinction.
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Wednesday, September 18, 2013 10:38 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] record locking
Liz-
Default locking for forms should always be No Locks, especially in a multi-user app. Default locking for a Recordset in code is always the equivalent of Edited Record (which is good) unless you specify something different when you execute the OpenRecordset. Edited Record in a form locks the record (and perhaps the entire page on which the record resides) as soon as the user "dirties" the record. If a user starts to edit a record and then goes off for a potty break of another cup of coffee, that can potentially lock other users out of a bunch of records for a long time. With No Locks, nobody gets locked out. You will have a locking problem only if two users try to edit the same record at the same time. When that happens, Access notifies the second user who tries to save that someone else has updated the record. The second user's changes get thrown away, but the user can simply re-enter the lost change.
HTH...
John Viescas
Sent from my iPad
On Sep 19, 2013, at 0:42, "Liz Ravenwood" <liz_ravenwood@beaerospace.com> wrote:
Pros, what's the difference between default record locking at edited record and open record with record locking or whatever it is?
I occasionally get an error on a lock and was googling and someone quoted Allen Browne as saying untick some record locking business of sorts.
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar