| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ODBC Password
Hello all,
I have a spreadsheet that has a number of queries. The queries connect to a SQL database via an ODBC connection. The ODBC Connection uses a common SQL Username and Password. When I refresh the queries the ODBC connection prompts me for the password for each query. I cannot use a trusted connection because multiple people will use the spreadsheet. How do I get the ODBC Connection to remember the password? Or is this even my problem? Best Regards Steve K. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ODBC Password
I figured it out.
When editing the Query Data Properties, Select the "Save Password" Option. DUH! "Stevek" wrote in message ... Hello all, I have a spreadsheet that has a number of queries. The queries connect to a SQL database via an ODBC connection. The ODBC Connection uses a common SQL Username and Password. When I refresh the queries the ODBC connection prompts me for the password for each query. I cannot use a trusted connection because multiple people will use the spreadsheet. How do I get the ODBC Connection to remember the password? Or is this even my problem? Best Regards Steve K. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ODBC setup won't save password | Excel Discussion (Misc queries) | |||
| PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them | Excel Programming | |||
| how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
| bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
| VBa, Password protected sheet fails to get unprotected with the same password | Excel Programming | |||
Linear Mode
