467,900 Members | 1,380 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Could Not Update; Currently Locked


I have made an small access Database that is used by 4-5 people every
day. Very often through the users get the message "Could Not Update;
Currently Locked" There is an entry about that problem in the MS
knowledge Base but I don't really understand how this could be solved.

I would be extremely greatful if someone could explain to me in simple
terms (if possible)what I need to do...

Thank you in advance


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
  • viewed: 28765
2 Replies

The problem is that if one user is editing a record, you may find that
lots of other records (typically 30-50) are also locked. This is
because Access stores its data in "pages" of data that are 2k in size,
so any record that is locked on the page will automatically lock all
the others.

You have three strategies for record locking. You can change these in
the form's "Record Locks" property.

1. No Locks (the default)

User 1 starts editing a record. User 2 then starts editing the same
record. User 1 exits the record, thus saving their changes. User 2 tries
to exit the record - they will receive the error message "This record
has changed since you started editing it", and are given the options to
either save their changes (thus overwriting User 1's changes) or copy
the record to the clipboard for possible insertion later.

2. Edited Record

This is, I suspect, what you are currently implementing. One user
editing a record in a "page" of data will lock a number of other
records. The locks are released when the user saves the record.

3. All records

Totally inflexible - only one user at a time can edit any record in
the table.

It's worth pointing out that Access XP and the new Access 2003 have
changed the strategy so that when a user edits a record, only that
record is locked and not the whole page.

Try searching on "Record Locking" in Access Help for more information.

Hope this helps and good luck.
Andy Briggs
Elmhurst Solutions Limited
Posted via http://dbforums.com
Nov 12 '05 #2

Use the OnDirty property of the form to start a timer. If the record
is not saved within a specified period of time, have the code undo the
changes which will then free up the record for someone else to be able
to edit.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Access Programming only with macros, no code | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.