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,

On Thu, 31 Jan 2008 10:38:44 -0800 (PST), Shiller <(E-Mail Removed)>
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.


>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,

On Feb 1, 12:08 am, Tom van Stiphout <no.spam.tom7...@cox.net> wrote:
> On Thu, 31 Jan 2008 10:38:44 -0800 (PST), Shiller <shill...@gmail.com>
> 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.
>
> >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,

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,