Encryption

ellenr

Registered User.
Local time
Today, 11:17
Joined
Apr 15, 2011
Messages
400
Not sure this question belongs here. I need to figure out a way to encrypt email account passwords in a db where all data is held in be odbc mysql tables. Is there a way? I can show asterisks in the data input field, but it goes into the table unencrypted.
 
only way is to hash it so that it is meaningless. But if users also have access to the hashing code they can reverse engineer it.

With regards the table, set the input mask property to password - which replaces the text with large dots (it does on my machine anyway). However a user can easily remove the format, so you are back to hashing.

Hashing is the alpha equivalent of shuffling a pack of cards with one or more additional packs thrown in and has been covered many times and there are many solutions, so best to google something like 'vba hashing' and find a solution that works for you.
 

Users who are viewing this thread

Back
Top Bottom