|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Open ExclusiveIf 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 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 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 > > 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... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200810/1 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) -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200810/1 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) 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.
How to protect Access application from Reverse Engineering
New virus "brastk.exe" Re: Access 03 Security you do not have permissions... I've locked myself out of design mode Creating user login set database password when converting AC00 to AC07 Password Protection need help with security how to backup through VBA code in Access 2007? |
|||||||||||||||||||||||