"Could not update; currently locked."

[David Portwood]

I have several users entering data into my app. I've received some
complaints about the app seeming to freeze followed by the above error
message popping up.

The database is set for record locking = No locks.

I think the error message occurs because another user (there are many) is
running a report from within the app. My reports typically query the table
that the data entry people are entering data into. I presume that Access
locks the table while the report is collecting the data. Or do you think it
might be something else?

Assuming the above is true, is there any way I can tell Access to run the
query/report without locking anything so the data entry people don't see
this error message any more?

 

[bhipwell via AccessMonster.com]

Have you split the database into front end and a back end? Doing so allows
multiple users to access forms, queries and reports while using information
from a single table.

B

 

[David Portwood]

Have you split the database into front end and a back end? Doing so

allows
multiple users to access forms, queries and reports while using
information
from a single table.

Yes, I have split the db into an fe and be.

I am also looking at increasing the Update Retry Interval (currently at 250
ms) and the Number of Update Retries (currently at 2). Is this a good idea?
Need some advice, please.

 

[Guest]

you wrote " I am also looking at increasing the Update Retry Interval
(currently at 250 > ms) and the Number of Update Retries (currently at 2). Is
this a good idea?"

Is this help you to prevent the problem
I have the same problem but no one can answer me correctly
I put my question on different forums but no one give me the easy solutions,
except microsoft support directly ,they suggest to use ODBC driver instead
JET beacuse that error is bug in miscrosoft aplication
you can find my question on diferent forums signed by dee


Korisnik "David Portwood" napisao je:

 

[Guest]

I still try to find a way to avoide problem of record locking.I have app.12
users in this aplication.There are other appl. in which I don't have this
problem.In this appl.I have the problem probably because this 12 users
constantly update a same goup of record.(shiping data)
Every user have his one copy of front end(same copy) but it seems that
workstation(PC) and access version is not the same
By two users this error is frequently ( maybe during the day 20 times ,or in
some period like 20 min constantly) other 10 user have this problem maybe one
time and not every day.
It seems that on all computers is installed access 2000 but when i copy the
same version of aplication on some computer looks like it is open in design
mode and on the another one not;
is it posible that opening in design mode by one user cause could not update
again I must say; ther is a difference when other user lock the record and
this problem when one user cause themselves to block the computer and
aplication
when tis happens , all users have dificulties(slow work etc..) until this
user break the aplication in task menager
we measure the time waiting that acceess themselves close the update
attempt (it took 10-15 min) and the quicker way is to use task manager
thus anyone can help with his thoughts,please


Korisnik "Dee" napisao je: