could not update, currently locked

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

 

[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().

 

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

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().

 

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

 

[slickdock]

Anyone?

 

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

 

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

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.