detrmine current user password for ado connection string

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
There is no way to programatically retrieve the current user's password
(unencrypted).

TC
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

autoexec string connect to db 3
Connection Problem 1
Tweak ADO to use a DB password 1
SQL-Statment Error "No value given for one or more required parame 1
Table format - connection string problem 1
SQL Scalar Valued function in VBA for a Access Project (ADP) 4
A2000 ADO Connection String Error 4
Recordset adLockReadOnly but still "currently locked by another user"! 1

Back
Top