Open Exclusive

[mlk]

If a coworker opens our database (on a network) exclusively on her machine, I
can still get in. Why is that?

If a different coworker opens the database exclusively on her machine, I can
not get in.

What is the difference between the set-ups? I don't want anyone to be able
to get in the database if another user has it opened exclusively.

(Note: The default open is set to exclusive in tools --> options -->
advanced on all of our machines as well)

Thanks,
MK

 

[Chris O'C via AccessMonster.com]

It means she didn't open the db exclusively. She'll be prevented from
opening it exclusively if:

1 - the db is already opened in shared mode
2 - she doesn't have permission to open the db exclusively
3 - she didn't use a method that guarantees the db is opened exclusively,
like a shortcut with the /excl command line switch or vba to open the db
exclusively

Chris
Microsoft MVP

 

[Chris O'C via AccessMonster.com]

That setting doesn't mean squat because it can be ignored when the user
*can't* open the db exclusively and opens the db anyway - in shared mode.

Chris
Microsoft MVP

 

[ELENA TIERNAN]

Why I cannot receive my e-mail- My system is blocked. I am working with a
proyect that is send to be corrected in Spanish, and I have problems to
receive. Please explain...Right now I cannot get my e-mails---Thank you.
Ele1946.

 

[mlk]

How do you give permission to open the db exclusively? I don't believe the
issue is 1 or 3, so I'd like to look into 2...

Thanks!

 

[Chris O'C via AccessMonster.com]

Unless you implemented user level security, it's either #1 or #3.

By default the admin user can open the db exclusively. You'd have to
implement user level security on the db file and not assign the user to the
admins group or a group that has database open exclusive permission.

See menu, tools > security > user and group permissions. Choose Object type:
database and look at the "open exclusive" checkbox for the groups your user
is assigned to.

Chris
Microsoft MVP

 

[Chris O'C via AccessMonster.com]

You'd be better served posting your question in a group for your email
program. This group is for questions about Microsoft Access database
security.

Chris
Microsoft MVP