Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Password function with MS Access SQL

Discussion in 'Information Technology' started by Rye, Nov 2, 2005.

  1. Rye

    Rye
    Expand Collapse
    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
     
  2. Loading...

    Similar Threads Forum Date
    I became victim by Password hacker Hard Talk May 27, 2012
    Legal Sharing Passwords with Spouse is Risky Breaking News Oct 14, 2011
    Password for Sikhs: "WAHEGURU" ! Spiritual Articles Apr 4, 2006
    MD Law College Sriganganagar's Annual Prize distribution function & Rhyth 2016 Language, Arts & Culture Mar 9, 2016
    5 K's: Symbolic or Functional? Questions and Answers Oct 21, 2014

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    There's nothing like that built into Access.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Rye" <Rye@discussions.microsoft.com> wrote in message
    news:2431EE42-353E-4947-8E80-40760B0E6999@microsoft.com...
    > 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
     

Share This Page