USL with no password?

[Guest]

I am trying to convince my manager to use the User Security Level provided by
MS Access by she does not want a member of our team to enter user
name/password everytime they need the database. (Too much work).

Is it possible to have USL without the passsword screen? Something like
using the Windows user login, for example.

Thank you very much
Mauricio Silva

 

[Joan Wild]

You cannot integrate Windows users with Access users directly, no.

However, if you have only one level of security needed (for all users), in
addition to the developer, you can secure it using ULS such that they don't
have to login. See http://www.jmwild.com/SecureNoLogin.htm

You could use the Windows username and set up your own security by creating
the necessary tables with the information. You could use the code at
http://www.mvps.org/access/api/api0008.htm to grab the username.