Encrypting only a column in Access table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone,

I need to have a particular column encrypted in MS Access table. For eg, I
would like to encrypt the Password column of LOGIN table. Is there any trial
tools that I can evaluate?

Thank you all.
 
Download the MD5 class from http://www.freevbcode.com/ShowCode.Asp?ID=741,
put clsMD5.cls into a standard module (or a class if you prefer), and use
DigestStrToHexStr() to convert all passwords to MD5 format.

When it comes time to test a user's password against the ones stored in the
database, call DigestStrToHexStr() to convert it to MD5 format, then compare
the result with what's stored in the database. That way, the passwords are
never decrypted.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top