I create a routine to test the connection, I already add the UID and password
to the connection string, but it still asking me for the UID and PWD, what
am I doing wrong? (does anybody help me?)

:(



Sheet1.Activate
ActiveSheet.Range("B2").Select

With Selection.QueryTable
.Connection = = "ODBC;DSN=MS Access Database;DBQ=C:\Information.mdb;
DefaultDir=C:\;DriverId=25;FIL=MS Access; MaxBufferSize=2048;PageTimeout=5;
uid=user; pwd=password ;"
.Refresh BackgroundQuery:=False
End With


"Anselmo" escribió:

I created an excell file, and I am refreshing the excell queries using
ActiveWorkbook.RefreshAll function, but everytime I need to enter the
username and password, is there a way to avoid enter the username and
password for each refreshed query, or just enter one time only??