Encryption and Decryption

[Sameal]

Could anyone point me in the right direction to find out how to encrypt and decrypt passwords so that the stored values for the password can not be read?

Is there any way to do this in VB or VBA? Or would I have to migrate to C++ to pull this one off?

 

[pcdaveh]

are you saying you DON'T want to see the passwords in the table? If so, my only question is why? What if a typo is made? How do you find errors? Why not set security up so the users can't access the table where they can see the passwords instead?

 

[Sameal]

Main reason I don't want to them to be viewable is because if they are viewable someone can steal the passwords out of your database. The exact same reason all passwords are encrypted...

If there is a typo in entering the password then I will code a function to reset the password, not to go in and see what it is.