ADO sql server password

[Rubble]

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

 

[Tim Williams]

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