I would like to convert my password field from text to MD5 format in
my table user. How do I go about making the conversion.
Thanks,
Eh, you'd use a function to do the conversion?=ConvertToMD5(some_text)
Of course you'd have to implement this function. Write it yourself, or
find a VBA implementation of the algorithm.
If you were doing this in DotNet, I think it's provided in the
framework.
Not sure what I'm missing here.
-Tom.
Thank you Tom,
Like Graham R Seach recommended in a previous posting, I downloaded
the MD5 class from http://www.freevbcode.com/ShowCode.Asp?ID=741, put
clsMD5.cls into a standard module, and I use
DigestStrToHexStr(some_text) to convert all passwords to MD5 format.
***don't put clsMD5.cls in a class module, because you'll receive an
"undefined error message..."***
Thanks again Tom, you're my hero.
Shiller,