By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,874 Members | 1,058 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,874 IT Pros & Developers. It's quick & easy.

could not update;currently locked > MDB is split and replicated.

P: n/a
I have users on different computers getting the error message "could
not update;currently locked" when trying to leave identical fields
after making a change on the same form but on different records.

MS Access 2002 MDB, front-end split from data. Data stored on network
server with front-end stored on local computer's desktop. Back-end data
is also replicated. All forms have "Record Locks" set to No Locks,
Recordset Type is Dynaset. Default database recordlocking is
record-level (but when I look at the properties of a table inside the
back-end I see 'replicated' checked but 'Record level locking' is
disabled and unchecked)

The form that is giving the error is based on a single table and has
fields on the form bound to the form's table. The error happens in
these fields.

The form also has many subforms (30) that are linked off to other
tables, most of these mini-subforms (one field on them) link to the
same table but different fields in that other table. These
mini-subforms are also used more than once on the form ('form2' is on
the main form twice, each with different name - but the same source
object). I don't know if these are an issue but I thought I'd mention
them anyway.

It sounds like page level locking is happening but I can't see how
except that the back-end database tables (that are replicated) have the
'record level locking' checkbox unchecked even though it is disabled.
What else could it be???

Really need some help,

Jul 7 '06 #1
Share this Question
Share on Google+
2 Replies

P: n/a
One incorrect thing I mentioned about, the properties of the table in
the back-end doesn't say "Record Level Locking" it says "Record Level

Jul 7 '06 #2

P: n/a
I tried one more test...

I created a canned DB from the access wizard. Split off the database,
everything worked fine. Then I created a replica of the Back-end and TA
DA... broken... same "Could not update; currently locked" error.

What's up?

Jul 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.