Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Query of Access Q
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:\timepo int;Driver= {Microsoft Access Driver (*.mdb)};DriverId=281;FIL=MS Access;MaxBufferSize=2048;MaxScanRows=8;PageTimeou t=5;SafeTransactions=0;Threads=3;UID=admin;UserCom mitSync=Yes; |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Using excel to access MS Access saved query | Excel Programming | |||
Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
Run Access query from Excel, input value to query being value in c | Excel Programming | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |