Converting Password field to MD5

[Shiller]

Experts,

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,

 

[Tom van Stiphout]

On Thu, 31 Jan 2008 10:38:44 -0800 (PST), Shiller <[email protected]>
wrote:

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.

 

[Shiller]

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,