SQL-function to encrypt password like password() in mySQL?

[Hyko]

Hi all,

in mySQL you can encrypt a password using the password function in SQL:

UPDATE tblUsers SET pwd=password([stringPWD]) WHERE userid=[intUserID];

Is there any similar function in access? I don't want to have all passwords
of the users in clear text in the tblUsers.

Thanks in advance for your hints,

Hyko

 

[John Viescas]

There is no function like that in Access - although you can certainly write
your own user-defined encrypt/decrypt functions. To keep a password from
being displayed, you can set the Input Mask property of the field to
Password. Access will display asterisks in the table datasheet or any query
built on the table and will also display asterisks when you type in the
field.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)