Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO sql server password
I have an ado connection set-up that pulls info from a sql server. Everything works fine, but there is some concern about the fact that the password for the sql server is sitting in my code. I know I can password protect the module so most cannot access the code, but I am wondering if there is a way to have the password show up as "*******" in my code so someone who does get into the code cannot see the password easily. Any ideas? I have resorted to building a text variable named Password that is built throughout the code - Password="5" & Password at one place and then at another spot it does Password="L" & Password until eventually I have my full password built and saved as Password. The problem is if someone is good enough to get into the code then I have to assume they are smart enough to step to the connection string and hover the variable. Any ideas would be appreciated -- also, on the locked code issue - I would actually prefer to not password protect the code so others could make adjustments if they want - which is another reason for wanting to encrypt the password. Thanks in Advance ! Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO sql server password
From the perspective of a pure VBA solution you're out of luck. Anyone with
the know-how to unlock your password could easily view the password. Unlocked code would be super-easy for anyone with even moderate knowledge to view the password. Only really secure solution would be to compile the DB access part into a dll or similar. Tim "Rubble" wrote in message ... I have an ado connection set-up that pulls info from a sql server. Everything works fine, but there is some concern about the fact that the password for the sql server is sitting in my code. I know I can password protect the module so most cannot access the code, but I am wondering if there is a way to have the password show up as "*******" in my code so someone who does get into the code cannot see the password easily. Any ideas? I have resorted to building a text variable named Password that is built throughout the code - Password="5" & Password at one place and then at another spot it does Password="L" & Password until eventually I have my full password built and saved as Password. The problem is if someone is good enough to get into the code then I have to assume they are smart enough to step to the connection string and hover the variable. Any ideas would be appreciated -- also, on the locked code issue - I would actually prefer to not password protect the code so others could make adjustments if they want - which is another reason for wanting to encrypt the password. Thanks in Advance ! Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sql server password entry during macro run | Excel Discussion (Misc queries) | |||
can not locate the internet server or proxy server | Excel Programming | |||
Save active sheet as "filename" on a remote server with username and password | Excel Programming | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) |