|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I have a user who is running using Excel to generate and SQL database
query through an ODBC connection. It works GREAT, but .... It
requires them to enter the sql password prior to data retrieval even
though the user/pw information is embedded in the query. For example,
click the button to generate the data and you immediately get a window
with sql login info including the correct user id and a **** out
password of the correct number of characters. If you simply retype the
password in place of the characters, it immediately connects. This
happens when Macro settings are set to medium. On LOW, no pw check.
IT security issues prevent their Excel from having LOW security. ANY
other way around this issue of having to type in the pw each time?
|
|
|