Access Bug

[Anastassios Giannaras]

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!

[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!

[Tom van Stiphout]

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!

[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!

[Rick Brandt]

"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

[Tom van Stiphout]

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>

[Lyle Fairfield]

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)

[Terry Kreft]

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)

[Anastassios Giannaras]

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!

[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!

[keyur shah]

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!