I'm following this thread...so i decided to made a test for the "locking level" ability, i placed a northwind.mdb as BE on a computer on a network, then i opened 3 FE on my laptop (i copied the FE 3 times and then opened them all), i opened "Products" form for all FE, but i had setted the form's property to "edited record" (all of 3 FE).
For the 1'st FE i tried to edit the 1'st record with succesfully...but i let the 1'st form stay opened, then i opened the same form (on 2'nd FE) and tried to edit 2'nd record...it didn't work,,,then i opened the 3'rd FE tried to edit the 3'rd record...it failed too...
From that experiment i make a conclusion that ms access "locking level" not behave properly like it should, it seem that all the page/table is locked even we had setted the form property to "edited record"...Sorry if my words confusing you since implementing English "time progress" grammar is difficult as writing 100 lines vba codes... :D
Regards
Hendra Agestha
--------------------------------------------
Pada Jum, 20/9/13, wrmosca@comcast.net <wrmosca@comcast.net> menulis:
Judul: RE: RE: [MS_AccessPros] record locking
Kepada: MS_Access_Professionals@yahoogroups.com
Tanggal: Jumat, 20 September, 2013, 9:45 PM
Liz
The
default record locking is for new forms. Unlike John, I use
Edited Record most of the time, but I'll keep his
suggestion in mind should I run up against locked
records.
Bill
--- In MS_Access_Professionals@yahoogroups.com,
<ms_access_professionals@yahoogroups.com> wrote:
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
|
beaerospace.com
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 (11) |
Tidak ada komentar:
Posting Komentar