Password function with MS Access SQL

[Guest]

Hello,

I have a question.. I've searched online and found that there was one user
that had used a password("value") function inside the SQL statement for
Access. However, when I tried, it says "Undefined Function 'password'"

I know there is a function with MySQL that simply encodes "value" inside the
password() function. Thats really all im looking for in my current project.
So basically, I would like to know, is there some type of similar function in
Access I can use?

(Sample SQL: "INSERT INTO users (username, pwd) VALUES ('Joe',
password('123')" <== this is what Im looking for)

Thanks

 

[Douglas J Steele]

There's nothing like that built into Access.