Printable View
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..
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.
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.