Password encryption

[papapishu]

Does access support the sql function "password"
I need a secure, encrypted password but my accessdb wont agree.
I wanna use a sqlquery like:
"insert into users (username, password) values ('someguy', password('hispassword'))"
but it seems as if ASP/Access wont allow this.
Does this mean I have to use an uncrypted password?

 

[Ed2020]

You can put an input mask on the password field in the table of "Password". That would mean that only people with design view access to the table can view the password (by removing the input mask).

Failing that it's fairly easy to write a simple encryption engine. I'm sure I have one somewhere, if you want it......

Ed Metcalfe.