detrmine current user password for ado connection string

[Jim]

In the code below, I want to pass the currently logged in
user and password instead of user "dummy" and
password "mummy"

CurrConn.Provider = "Microsoft.Jet.OLEDB.4.0"
CurrConn.Open CurrentProject.BaseConnectionString & ";User
ID = dummy;Password = mummy;"
sqlstmt = "SELECT * FROM PIGGEDHEATS WHERE heatnumber
= """ & Forms.Fpig.List12 & """"
pigTB.Open sqlstmt, CurrConn, adOpenForwardOnly,
adLockReadOnly
With pigTB

 

[TC]

There is no way to programatically retrieve the current user's password
(unencrypted).

TC