Exclusive User

[Michael]

I am using Access 2002.

Basically, we have a database at my place of employment
that is share by about 20 users. Occationally no one
will be able to open the database if a certain user is
already in. There will be an error message saying
something like "You do not have permission to open this
database because 'computer name' has it open
exclusively." This does not affect the users that are
already in the database, only the ones who are trying to
get in. Also, if I reopen the database on the computer
that supposively has it open exclusively then everyone
can get back in. Any ideas at why this is happening so
randomly? I have the understanding that everyone has the
same permissions, and 3 different people have been
considered the "exclusive" user thus far. Thanks for any
help!

Michael

 

[Douglas Mewis]

For the computers that are violating the rule of exclusive access, you will
find that their default open method at:
Tools > Options > Default Open Mode is checked as "Exclusive" instead of
"Shared". Make sure anyone who is opening the database has this item
checked to shared.

Now I have a question for yall VBA experts, how can you override default
user settings in this regard and force everyone except maybe system
administrators and developers into the shared mode?

 

[Douglas Mewis]

Verify your file locking mode and make sure that it is set to lock the
records being edited rather than the entire table.

 

[TC]

(snip)

Now I have a question for yall VBA experts, how can you override default
user settings in this regard and force everyone except maybe system
administrators and developers into the shared mode?

No can do on that one (AFAIK), because the exclusive/shared mode selection
is actioned before any VBA code is run.

HTH,
TC