469,590 Members | 2,464 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Access Bug

Hi,

I have a weird problem, I have a database that 10 to 15 people use
daily. Very often they get an error message "Could not Update Currently
Locked" and after that they usually get stack for 10-20 minutes.

I think this is a bug but can anyone help me and tell me how to avoid
it?

Thanks

Anastassios
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
10 3056
TC
Why do you think it's a bug?

If any of your code is using so-called "pessimistic locking", and someone
starts editing a recrd, then goes for a coffee, then comes back 15 minutes
later & saves the record, this is exactly what *should happen*.

HTH,
TC
"Anastassios Giannaras" <an**********@yahoo.co.uk> wrote in message
news:3f*********************@news.frii.net...
Hi,

I have a weird problem, I have a database that 10 to 15 people use
daily. Very often they get an error message "Could not Update Currently
Locked" and after that they usually get stack for 10-20 minutes.

I think this is a bug but can anyone help me and tell me how to avoid
it?

Thanks

Anastassios
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #2
On Wed, 5 Nov 2003 12:28:14 +1200, "TC" <a@b.c.d> wrote:

Often reported (meaning: check with groups.google.com) that this "bug"
can occur in single-user mode as well, for example if two forms
conflict.

-Tom.

Why do you think it's a bug?

If any of your code is using so-called "pessimistic locking", and someone
starts editing a recrd, then goes for a coffee, then comes back 15 minutes
later & saves the record, this is exactly what *should happen*.

HTH,
TC
"Anastassios Giannaras" <an**********@yahoo.co.uk> wrote in message
news:3f*********************@news.frii.net...
Hi,

I have a weird problem, I have a database that 10 to 15 people use
daily. Very often they get an error message "Could not Update Currently
Locked" and after that they usually get stack for 10-20 minutes.

I think this is a bug but can anyone help me and tell me how to avoid
it?

Thanks

Anastassios
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Nov 12 '05 #3
TC
Not disagreeing, but, if two forms try to edit records in the same data
page - and they are using pessimistic locking - the second should remain
"locked out" until the first has saved its changes - no? Why is that a
"bug"?

TC
"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:ui********************************@4ax.com...
On Wed, 5 Nov 2003 12:28:14 +1200, "TC" <a@b.c.d> wrote:

Often reported (meaning: check with groups.google.com) that this "bug"
can occur in single-user mode as well, for example if two forms
conflict.

-Tom.

Why do you think it's a bug?

If any of your code is using so-called "pessimistic locking", and someone
starts editing a recrd, then goes for a coffee, then comes back 15 minuteslater & saves the record, this is exactly what *should happen*.

HTH,
TC
"Anastassios Giannaras" <an**********@yahoo.co.uk> wrote in message
news:3f*********************@news.frii.net...
Hi,

I have a weird problem, I have a database that 10 to 15 people use
daily. Very often they get an error message "Could not Update Currently
Locked" and after that they usually get stack for 10-20 minutes.

I think this is a bug but can anyone help me and tell me how to avoid
it?

Thanks

Anastassios
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #4
"TC" <a@b.c.d> wrote in message news:1068005743.906488@teuthos...
Not disagreeing, but, if two forms try to edit records in the same data
page - and they are using pessimistic locking - the second should remain
"locked out" until the first has saved its changes - no? Why is that a
"bug"?


But this can happen (at least in A2K) with No Locks set as the default and
while users are NOT editing records on the same page. I would describe
that as a bug.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #5
On Wed, 5 Nov 2003 14:01:12 +1200, "TC" <a@b.c.d> wrote:

I used the word "bug" in quotes. I don't for a moment think there is a
bug in this area. "Bugs" often are correlated with limited
understanding of how things work.

-Tom.

Not disagreeing, but, if two forms try to edit records in the same data
page - and they are using pessimistic locking - the second should remain
"locked out" until the first has saved its changes - no? Why is that a
"bug"?

TC

<clip>
Nov 12 '05 #6
Tom van Stiphout <to*****@no.spam.cox.net> wrote in
news:pl********************************@4ax.com:
On Wed, 5 Nov 2003 14:01:12 +1200, "TC" <a@b.c.d> wrote:

I used the word "bug" in quotes. I don't for a moment think there is a
bug in this area. "Bugs" often are correlated with limited
understanding of how things work.


Well put, Tom! Much better than I could have expressed it.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #7
But I didn't understand him, so is this a bug ? <g>.
Terry

"Lyle Fairfield" <Mi************@Invalid.Com> wrote in message
news:Xn*******************@130.133.1.4...
Tom van Stiphout <to*****@no.spam.cox.net> wrote in
news:pl********************************@4ax.com:
On Wed, 5 Nov 2003 14:01:12 +1200, "TC" <a@b.c.d> wrote:

I used the word "bug" in quotes. I don't for a moment think there is a
bug in this area. "Bugs" often are correlated with limited
understanding of how things work.


Well put, Tom! Much better than I could have expressed it.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

Nov 12 '05 #8


I think it's a bug because if you type "could not update, currently
locked" in the Microsoft knowledge base it reports this problem as a
bug.

http://support.microsoft.com/default...b;en-us;331594

I admit, I don't really understand all this.

The database is sitting on a server a people access it from terminals,
but noone is using the same record at the same time...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #9
TC
But that error is unlikely to be the cause of your problems unless you are
using transactions :-)

TC
Anastassios Giannaras <an**********@yahoo.co.uk> wrote in message
news:3f*********************@news.frii.net...


I think it's a bug because if you type "could not update, currently
locked" in the Microsoft knowledge base it reports this problem as a
bug.

http://support.microsoft.com/default...b;en-us;331594

I admit, I don't really understand all this.

The database is sitting on a server a people access it from terminals,
but noone is using the same record at the same time...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #10
Seems u are using VB and locking level is set to pessimistic locking
instead of other way round.. change this option and ur problem would be
gone with the wind.

Keyur Shah
Verizon Communications
732-423-0745

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

63 posts views Thread by Jerome | last post: by
13 posts views Thread by Simon Bailey | last post: by
reply views Thread by Frederick Noronha \(FN\) | last post: by
64 posts views Thread by John | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
37 posts views Thread by jasmith | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.