Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

retrieving password

Status
Not open for further replies.

vveluru

Programmer
Joined
Jan 11, 2008
Messages
3
Location
US
I have a small application in ms access that needs to connect to sql server database for certain data and process that information. Is there a way to retrieve the lan password of a specific user id to be able to connect to the sql server database using that user id and password. Thank you for your help in advance.
 
Why not create a user for them on the SQL Sever and use trusted connection
 
How do I use the trusted connection? Won't it need any password for connecting to the database? Please send me a sample code, if possible. Thank you for your help.
 
I assume you are using a DSN. When you set it up it gives you the option of signing in with a name and password or trusted connection.
(Might be listed as "With Windows NT authintication...)

If the person is a user on the SQL Server database it will let them in.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top