how to hide password fields when connecting odbc?

[Ryno Bower]

Hello all,

I have a table for users. One of the fields in this tblUsers has a password field with input mask password.
All is fine through the whole database!

My concern is when I go to excel and do an odbc query through microsoft query, the password field shows th actual letters in the field. As is access it shows ***** but in the ms query it shows e.g apple for the password.

Is there a way that when in ms query the password could still be ***** or just blank or even hidden completely?

It wouldn't help if users can just go ms query and retrieve passwords from there.

Does anyone have suggenstion to do as I explained above or help me approach in a different way!

Thanks

[Rabbit]

Plaintext passwords should never be stored. Instead, store the hash.

[Mihail]

What is "hash", Rabbit ?
Thank you !

[NeoPa]

See AES Encryption Algorithm for VBA and VBScript, RC4 Encryption Algorithm for VBA and VBScript & SHA2 Cryptographic Hash Algorithm for VBA and VBScript.