S
Seanie
I have a Excel code that queries an Access database for various
figures etc. I recently protected this Access database with a
password. I am now getting "Enter Username/Password" dialog box when I
try and refresh the query now.
How can I amend my query to enter the Username/Password when I refresh
my query? I'm not sure what the username is as I haven't set this in
Access, so not sure why it is asking for this. What appears in the
dialog box in the Usernane field is "Admin" NB I have tried entering
the actual password manually in this dialog box, but it doesn't accept
this.
Typically I just "refresh" my query in excel with this line:-
Selection.QueryTable.Refresh BackgroundQuery:=False
If I got into "Edit Microsoft Query", under the connection string
definition, the following appears, I assume this is where I would have
to enter my password etc (but what is the username??)
DBQ=C:\arsenal\arsenal_be.MDB;DefaultDir=C:\timepoint;Driver=
{Microsoft Access Driver (*.mdb)};DriverId=281;FIL=MS
Access;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;
figures etc. I recently protected this Access database with a
password. I am now getting "Enter Username/Password" dialog box when I
try and refresh the query now.
How can I amend my query to enter the Username/Password when I refresh
my query? I'm not sure what the username is as I haven't set this in
Access, so not sure why it is asking for this. What appears in the
dialog box in the Usernane field is "Admin" NB I have tried entering
the actual password manually in this dialog box, but it doesn't accept
this.
Typically I just "refresh" my query in excel with this line:-
Selection.QueryTable.Refresh BackgroundQuery:=False
If I got into "Edit Microsoft Query", under the connection string
definition, the following appears, I assume this is where I would have
to enter my password etc (but what is the username??)
DBQ=C:\arsenal\arsenal_be.MDB;DefaultDir=C:\timepoint;Driver=
{Microsoft Access Driver (*.mdb)};DriverId=281;FIL=MS
Access;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;