Access Security

[Richyrich]

Does anyone know how to pick up a users password from NT? (Username found with Environ). What I want to do is use a persons NT login credentials to login to my access database as I am tired of having to set numerous passwords for all the access databases I have developed.

Hope that makes sense..

[Clunietp]

why don't you put your Access database on a NT server with NTFS permissions set? This way, you can control who has access to the database without having to manually code it in.

[JHausmann]

You could convert your database to SQL server which allows "trusted" connections.

:)

The only problem with Tom's suggestion is that it may be significantly slower than you'd like.