Can I Set permissions for a .mdb using Windows login?

J

Just_acex3

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?
 
G

Guest

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.
 
D

Douglas J. Steele

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
 
Top