the passive shutdown/connection control

[Paul James]

I tried to open an mdb file when one of my associates already had it open,
and I got an error message I've never seen before. It read:

The database has been placed in a state by user Admin on machine DGD-1333
that prevents it from being opened or locked. (Error 3734)

This error occurs when the new passive shutdown/connection control is being
used. This error message indicates that a user set the database in a mode
that will prevent other users from opening it.

I couldn't find any information about the "new passive shutdown/connection
control" in Access help.

I would like several of us to be able to open this database at the same
time. Where can I find the shutdown/connection control, and what can I do
so that it doesn't prevent multiple users from opening the db?

Thanks in advance.

Paul

 

[Albert D. Kallal]

Hum, can't say I hear of that new control either.

However, generally there is just a few reasons why you can't have more then
one person in the file.

First, make sure the user is not opening the file in exclusive mode (this is
mode designed exactly for the purpose of allowing only one user). Check the
settings:

tools->options->General tab - verify the setting for open:
Exclusive = one user
Shared = multi user

So, make sure the settings is shared.

The other issue is that all users need FULL permissions to that directory
where the mdb file is. That is read, write, delete, and create permissions!.
Read/write permissions is NOT enough, and if create and delete permissions
are not present, then once again the file will be opened exclusive (singe
user mode).

And, if everyone is out of the file, then try delete the .ldb file. That
..ldb file is a locking file that gets created and deleted during operations.
It could be messed up, and thus you can delete it IF NO users are currently
in the system. It will get re-made when the first user runs the application
again.

Try any, and all of the above.

 

[Paul James]

Thanks for your help again, Albert.

FYI - I found it in the Advanced tab in v 2002.