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

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

 

[Douglas J. Steele]

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

 

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

 

[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