Get ODBC Windows User Name/password

[Jen]

I have found information to save your user name/password for the ODBC linked
tables, but in order to do this, I would need to delete & re-link all the
tables in all the DBs I have, checking the "save password" box when
re-linking.
While I could do this, I believe there must is another way to grab the
Windows user name/password using VBA so you do not have to "sign in" to
establish the connection to the linked tables.

I have searched the web & found many examples of code to get the username,
but I also need the password & I need the code to "login".

Thanks!

 

[Daniel Pineault]

To get the current user's network username you can simply use the code found at

http://www.mvps.org/access/api/api0008.htm

as for the password, I have my doubt it can be retrieved, but hopefully
someone else will be able to guide you on that one.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Douglas J. Steele]

Fortunately, it's not possible to retrieve a password. Windows Security
wouldn't be very secure if you could...