Users locking database somehow (Access 2.0)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

B. Harwood - 16 Mar 2005 21:42 GMT

I have an old Access 2.0 application (don't ask) that about 20 users
in my organization work with. Till now, we have had no problem with
multiple users being in the database at the same time. However,
recently, it seems that when certain users are in the database, others
(including myself) cannot get in.

I have used the "ldb viewer" to find out who is using the application
during those times and have checked all of those machines. No one is
opening the database "exclusively", and all of the multiuser settings
in the options are set to "Shared"; however, two users seem to be able
to lock all others out.

Can anyone tell me what might possibly be enabling just certain users
to lock the database without opening it exclusively or having their
multiuser/ODBC settings set to Exclusive?

Brenda

Reply to this Message

david epsom dot com dot au - 17 Mar 2005 06:49 GMT

Windows will opportunistically try to upgrade shared locks
to exclusive locks if it gets the chance. It is supposed
to back down to shared locks if a second user wants to
access the file. There may be some problem with the way
the Win16 emulation system handles this: perhaps you
could try turning off OPLOCKS at the server.

Search MS for information on opportunistic locking and
OPLOCKS registry settings.

(david)

>I have an old Access 2.0 application (don't ask) that about 20 users
> in my organization work with. Till now, we have had no problem with
[quoted text clipped - 13 lines]
>
> Brenda

Reply to this Message