CODEWITHSUNDEEP
ms-access
user1098708
user1098708

Reputation: 63

Intermittent message "Could not update; currently locked", While inserting record in ACCESS 2000

Below are the Form Properties:

  1. Navigation Buttons : Yes
  2. Record Lock: No Lock

Front end, is on the users Local m/c. Which is inserting the record in a Access DB of Network location, on clicking of Navigation buttons, as Table is link to table on Network location.

I am getting this eror message: "Could not update; currently locked"; Some times it works fine.

Can somebody help me on this? I wasted 3 days, but I did not find any thing, that could help me.

Upvotes: 1

Views: 22088

Answers (1)

Fionnuala
Fionnuala

Reputation: 91376

There are three places where locking can be set:

  1. The back-end database under Tools->Options
  2. The front-end, same place
  3. The various forms, on the data tab

If you do not think users will often come into conflict, you can set these to No Locks (optimistic locking). If two users try to change the same record, they will get a message.

Page level locking is the default, and is faster. Allen Browne suggests that you do not tick Use record level locking.

Track name autocorrect is an anti-feature and should not be used, except in very specific instances. It causes all sorts of strange problems.

It is nearly always a good idea to compact and repair if odd things are happening.

Some reading

Set options for a shared Access database (MDB) http://office.microsoft.com/en-us/access-help/set-options-for-a-shared-access-database-mdb-HP005188297.aspx

Page-Level Locking vs. Record-Level Locking http://msdn.microsoft.com/en-us/library/aa189633(v=office.10).aspx

Help Access run faster http://office.microsoft.com/en-us/access-help/help-access-run-faster-HA010235589.aspx

Upvotes: 3

Related Questions