Hi Liz,
> "Is it possible that an append query could lock an entire table?"
that depends on the default Client Settings (different for every client -- in other words, every machine or virtual machine).
This means your users may have different settings unless your code changes it (in which case, it should save what they had and restore it). I cover the Access defaults (glossyily -- is that kind of a word?) in a video on YouTube here:
http://www.youtube.com/watch?v=CF9n0B3MU_w
it is 16 minutes so get comfortable ....
If you want to jump right to the record locking stuff, click this link instead:
http://www.youtube.com/watch?v=CF9n0B3MU_w#t=11m18s
Warm Regards,
Crystal
*
(: have an awesome day :)
*
> "Is it possible that an append query could lock an entire table?"
that depends on the default Client Settings (different for every client -- in other words, every machine or virtual machine).
This means your users may have different settings unless your code changes it (in which case, it should save what they had and restore it). I cover the Access defaults (glossyily -- is that kind of a word?) in a video on YouTube here:
http://www.youtube.com/watch?v=CF9n0B3MU_w
it is 16 minutes so get comfortable ....
If you want to jump right to the record locking stuff, click this link instead:
http://www.youtube.com/watch?v=CF9n0B3MU_w#t=11m18s
Warm Regards,
Crystal
*
(: have an awesome day :)
*
On Monday, June 16, 2014 9:34 AM, "Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Oh good. I can rule that one out then. Thanks my life saving mvp pros!
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, June 16, 2014 8:22 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: append query instead of update query
Sent: Monday, June 16, 2014 8:22 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: append query instead of update query
An Append query should lock only the "empty" blocks available for insert.
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)
On Jun 16, 2014, at 10:00 AM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Thanks Bill,
Logically that is the case to me too, and besides that, I've seen how network interruptions cause this kind of issue.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, June 16, 2014 7:46 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: append query instead of update query
Sent: Monday, June 16, 2014 7:46 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: append query instead of update query
Liz
John would probably know for sure, but I don't think an append would lock the entire table. It seems to me like this would be a case for locking at a record level.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
Pros, some time ago I inquired about an update query possibly locking the whole table and it could have been correct. I changed the way I did things to now run an append query.
It seemed to have fixed things, but since we'd been running an older version (the update) and the newer version (the append) at the same time I would occasionally get the error.
Another complicated thing is that I've seen network interruptions lock the tables because Citrix doesn't lose the connection or something.
However, I was wondering, that is it possible that an append query could lock an entire table?
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.
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.
__._,_.___
Posted by: Crystal <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar