encypting sql connection string
Posted on 2013-05-13
I am connecting to sql server using vba and the ADODB connection method. I am worried that even with the vba project protected someone could access the connection string, username and password. There are so many tools on the market to unprotect vba projects that I was wondering if there are anyother options. I would prefer to not have to prompt my user for the password. I am also currently using the obfusc funtion to help encrypt the connection but all someone would have to do is understand the function to decrypt it.