User Security & Windows Login

G

Guest

In the distributed db I maintain, I'm currently using the Windows login ID to
identify users in a couple of places (forms, tables), but since I haven't
setup the user-level security, eveyone that uses the front-end is "admin" by
default.

I'd like to secure the app a bit more, and make that transparent to the
users. Is it possible to implement user-level security without requiring yet
another login and password? Can I force the workgroup file to use everyone's
Windows user ID?

Thanks.
 
D

Douglas J. Steele

Sorry. Access doesn't integrate with Active Directory: there isn't the
equivalent of SQL Server's Trusted Connection.

Do any of the users need to have admin access (or, more precisely, do you
need to be able to assign different permissions to different users)? Joan
Wild explains how you can secure a database without requiring logon at
http://www.jmwild.com/SecureNoLogin.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top