PDA

View Full Version : Encrypt password for database access



Romulo Avila
08-29-2017, 05:15 AM
Good Morning,


I have a spreadsheet that accesses a database, would have some way to encrypt the password or some way that the password can not be viewed?

==> Connection example

Set gCon = New ADODB.Connection
gCon.Open "provider=msdaora; data source=BDDados01; user id = John; password = ******x1234;"


Thank you for your help

Simon Lloyd
08-29-2017, 06:40 AM
Take a look in our knowledge base http://www.vbaexpress.com/kb/getarticle.php?kb_id=951

Romulo Avila
08-29-2017, 10:03 AM
Good afternoon,

I am new to VBA and I was wondering how I will use this function to encrypt the password.

Thanks again.