Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Returning Password (XP SP2)

    I have a two part question. Assuming that I have an Access database containing a User's e-mail address and a password:

    How do I get the user input from the user interface on a website into Access?

    How do I find the Password field from the user's e-mail address?

    Thanks,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Returning Password (XP SP2)

    No idea about the first question.

    Say that you have stored the e-mail addresses in a table tblMail with fields EMail and Password. You can then use

    DLookup("Password", "tblMail", "[EMail] = " & Chr(34) & <userinput> & Chr(34))

    to retrieve the password belonging to the e-mail address. The <userinput> can be a string variable or a form control containing a string, depending on how the first question is answered.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Returning Password (XP SP2)

    Actually, when we take the approach you are investigating, we usually have an ASP page that actually appends a record to a table that is a request for passwords, and we then have a task which runs periodically that looks at any records in the table that have not been processed, finds the password or assigns a new one randomly, and generates an email to the email address submitted.

    There are some issues to be dealt with however - what happens when a person wants to change their email address? And how do you deal with bounced emails? Finally, emailed passwords aren't terribly secure, so some people feel you are taking an unreasonable risk in emailing them.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •