|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Can I Set permissions for a .mdb using Windows login?Am I able to set user permissions to my database using the windows login
name. I want to restrict some access to the database but don't want to have users entering a password everytime they want use it? Access User-Level Security does not integrate with the Windows login name.
However, depending on what your requirements are, check what Joan Wild has at http://www.jmwild.com/SecureNoLogin.htm -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Just_acex3" <Just_ac***@discussions.microsoft.com> wrote in message news:C07D47B3-0A06-4251-918F-81A0094E8783@microsoft.com... > Am I able to set user permissions to my database using the windows login > name. I want to restrict some access to the database but don't want to > have > users entering a password everytime they want use it? Of course. Speak to your Network Administrator about providing
a secure network share that only some users have access too. Put the data file in that location. Show quoteHide quote "Just_acex3" <Just_ac***@discussions.microsoft.com> wrote in message news:C07D47B3-0A06-4251-918F-81A0094E8783@microsoft.com... > Am I able to set user permissions to my database using the windows login > name. I want to restrict some access to the database but don't want to have > users entering a password everytime they want use it? Just to clarify.
While that will limit who can access the database, it won't control what they can do within the database if they can access it. There's no equivalent to "Trusted Connection" in Access: you must create a UserName, and the user must log on with that user name and password in order to use Access User-Level Security. However, depending on what restrictions are desired in terms of permissions for those who can access the database field, you might check what Joan Wild has at http://www.jmwild.com/SecureNoLogin.htm -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) <david@epsomdotcomdotau> wrote in message news:OEQIy46LHHA.2140@TK2MSFTNGP03.phx.gbl... > Of course. Speak to your Network Administrator about providing > a secure network share that only some users have access too. Put > the data file in that location. > > > > "Just_acex3" <Just_ac***@discussions.microsoft.com> wrote in message > news:C07D47B3-0A06-4251-918F-81A0094E8783@microsoft.com... >> Am I able to set user permissions to my database using the windows login >> name. I want to restrict some access to the database but don't want to > have >> users entering a password everytime they want use it? > > 
Other interesting topics
How secure is Access 2007
Access 2007 Security Shared mdw user level security user and group permissions on basis of data Disable Shift Key in Access 2007? no permissions for any users Copy Forms and Tables from Secure DB to other Secure DB EuroPKI07 Call for Papers How to hide Database Window for users |
|||||||||||||||||||||||
