could not update, currently locked

S

slickdock

Users INTERMITTENTLY getting this error, access xp: "could not update,
currently locked"

Continuous form, upon clicking on the last blank record in the form, before
typing text, the error message appears: "could not update, currently locked"

The form's underlying table has a default field value on the [DateCreated]
field of Date(), and a default field value on the [TimeCreated] field of
Now(). Other than that there is no code running on the form itself. User just
clicks on the [Comment] field and gets the error.

Please help if you can. THank you.
 
C

Chris O'C via AccessMonster.com

This happens in a multiuser db when page level locking or table level locking
is used and a default value is inserted into a record. Use row level locking.


Chris

Users INTERMITTENTLY getting this error, access xp: "could not update,
currently locked"

Continuous form, upon clicking on the last blank record in the form, before
typing text, the error message appears: "could not update, currently locked"

The form's underlying table has a default field value on the [DateCreated]
field of Date(), and a default field value on the [TimeCreated] field of
Now().
 
S

slickdock

I checked the properties of the form. Record Locks was set to No Locks. I
don't see a choice for row level locking.

If I check the properties of the table, I see a check box for Row Level
Tracking, which is unchecked. Is that what you are referring to? By the
description on the help menu, it doesn't seem like it.

Chris O'C via AccessMonster.com said:
This happens in a multiuser db when page level locking or table level locking
is used and a default value is inserted into a record. Use row level locking.


Chris

Users INTERMITTENTLY getting this error, access xp: "could not update,
currently locked"

Continuous form, upon clicking on the last blank record in the form, before
typing text, the error message appears: "could not update, currently locked"

The form's underlying table has a default field value on the [DateCreated]
field of Date(), and a default field value on the [TimeCreated] field of
Now().
 
S

slickdock

Still waiting for clarification, but in the meantime, if I put the default
value on the textbox in the form instead of on the field in the table, would
this be a solution?
 
J

JimBurke via AccessMonster.com

You might want to check the locking options in Tools, Options, on the
Advanced tab. those may be need to be changed. Pretty sure you want 'Open
Databases using record-level locking' checked, DON'T want Default record
locking set to All Records. Can't say this is the problem but it's worth
checking.
Anyone?
Users INTERMITTENTLY getting this error, access xp: "could not update,
currently locked"
[quoted text clipped - 8 lines]
Please help if you can. THank you.
 
S

slickdock

All settings were as you described, so that's not the problem. Anyone else?
Also, the database is split into front end (forms, reports, queries, etc.)
and back end (tables)

JimBurke via AccessMonster.com said:
You might want to check the locking options in Tools, Options, on the
Advanced tab. those may be need to be changed. Pretty sure you want 'Open
Databases using record-level locking' checked, DON'T want Default record
locking set to All Records. Can't say this is the problem but it's worth
checking.
Anyone?
Users INTERMITTENTLY getting this error, access xp: "could not update,
currently locked"
[quoted text clipped - 8 lines]
Please help if you can. THank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top