couldn't update currently locked

[Jennifer Gies]

I have a database that is used for 12 hours blocks by more
that 125 users at a time. Several times a day the users
are receiving the message Currently Locked Couldn't
update. Does anyone know why this is happening and how it
can be stopped. The users are not trying to access the
same records. They are just adding records to the
database.

If the database stays locked to long it is corrupting my
back end.

I would even like to know what user has the database
locked.

Any help of suggestions would be greatly appreciated.
Thanks!

 

[Patrick.]

Hi,

What version of access r u using? 97?. back-end is jet or
a dedicated sql server (MS,Oracle, you name it) ?
Up to version 97, access uses a so called page-locking,
that is, 1024 bytes.
now, a user is accessing a specific record, and he/she is
editing or inserting it and not yet saved/committed
(dirty record), the preceding and following records are
locked too. depending the recordsize, that are 1 to n
records.
there are 125 users! is there a need of online/real-time
system to any user! what about day-end replication, that
is, saving clients data to the centralized server.
if you are using access 2000 or higher, try setting: Tools-
Options-Advanced-Open Databases using record-level locking

regards
patrick