| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.vb.database.odbc,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.sdk
|
|||
|
|||
Q:Excel/ODBC/Login ....
I have the same issue. Did you find a solution?
Thx MSweetG222 "Verner Jensen, Ã…lborg" wrote: Hi' there ! My situation is this; My customer have a hole bunch of different Excel workbooks - with VB code inside. In this VB code the user/pwd to the ODBC connection is hardcoded. This hardcoding is not approved by audit. Is there any smart way (opposed the insert a login-dialogbox in each of those workbooks) - to solve this problem? What I thought of, is to make a button on my menubar to etablish the ODBC connection and regardless of wich workbook I open - hold this connection open. But somethins tells me, that the code should beplaced in a workbook - and not directly in Excel.... PS. Is it possible to grap to windows login and pwd - and use with the ODBC connection? Thanx in advance... Rgds, Henrik |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ODBC Microsoft Access Driver Login Failed | Excel Discussion (Misc queries) | |||
| ODBC Microsoft Access Driver Login Failed - Excel 2003 | Excel Discussion (Misc queries) | |||
| ODBC Microsoft Access Driver Login Failed | Excel Worksheet Functions | |||
| ODBC Excel Driver Login Failed. Could not find installable ISAM | Excel Discussion (Misc queries) | |||
| Q:Excel/ODBC/Login .... | Excel Discussion (Misc queries) | |||
Threaded Mode
