Home All Groups Group Topic Archive Search About
Author
22 Oct 2008 2:28 PM
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

Author
22 Oct 2008 3:27 PM
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


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

Author
23 Oct 2008 12:19 PM
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!

Show quoteHide quote
"Chris O'C via AccessMonster.com" wrote:

> 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
>
>
> mlk wrote:
> >If a coworker opens our database (on a network) exclusively on her machine, I
> >can still get in.  Why is that?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200810/1
>
>
Author
23 Oct 2008 1:49 PM
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


mlk wrote:
>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...

Author
22 Oct 2008 3:30 PM
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


mlk wrote:

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

Author
23 Oct 2008 12:05 PM
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.


On 10/22/08 11:30 AM, in article 8c0d5591847ec@uwe, "Chris O'C via
AccessMonster.com" <u29189@uwe> wrote:

Show quoteHide quote
> 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
>
>
> mlk wrote:
>
>> (Note: The default open is set to exclusive in tools --> options -->
>> advanced on all of our machines as well)
Author
23 Oct 2008 2:43 PM
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


ELENA TIERNAN wrote:
Show quoteHide quote
>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.

--
Message posted via http://www.accessmonster.com