Hi,
Does the password command automatically encrypt data within the parenthesis? Or is ther another command similar to this one that works?
ta
Kai
Printable View
Hi,
Does the password command automatically encrypt data within the parenthesis? Or is ther another command similar to this one that works?
ta
Kai
What are you talking about? :confused:
I don't understand your question.Quote:
Originally Posted by kaihirst
In generic ANSI standard SQL there is a function genrally used in mySQL called PASSWORD()...
Within the parenthesis, your password goes and its encrypted. Now, I amunder the impression that its mySQL that encrypts the data withinthe parenthesis and not the function itself, but I could be wrong on this one, and this is what I want to know.
does the Password function when used in Access encrypt the data within its parenthesis or is it just generic to mySQL, and if so, is there a similar command using ANSI in Access...
Is this any easier?
Kai
Haven't heard about that Password() function until you mentioned it here... Have you tried it with Access yet? I am under the impression that it maybe for MySQL only and not applicable for Access but I may be wrong...
Neither have I... :rolleyes:Quote:
Originally Posted by dee-u
Hi,,
yeah its a native funcionto mySQL ...
So guys...
Any suggestions on a native function in Access that encrypts passwords??
Ta
Kai
You will have to do it YOURSELF - we have plenty of encryption samples arround here so just search. Good luck.
Take a look at CAPICOM in the CodeBank. Microsoft released it, and a few servers have it by default.