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

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" <(E-Mail Removed)> wrote in message
news:7500DE22-BD9F-4CB6-B179-(E-Mail Removed)...
>
> 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