Results 1 to 7 of 7
  1. #1
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124

    Can users set their password?

    Hi


    Is there a way, where I can give a option in login form for users to set or change their password for db?

  2. #2
    ashu.doc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    124
    any suggestions on this one?

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    I assume that you currently have a combo box or text box for the user name and a text box for their current password. My suggestion would be to add two hidden text boxes on the login form. One for the new password and another for it's confirmation. Once the current password has been confirmed, the two new text boxes can be shown.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #4
    ashu.doc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    124
    Hi
    Thanks for the reply, to be honest I am a beginnner so I dont have much idea. I have something like this which I have seen on you tube and put it in my application:

    Click image for larger version. 

Name:	untitled.JPG 
Views:	37 
Size:	18.9 KB 
ID:	9388

    and when user enter a predefined username and password and click enter this code runs

    Private Sub Command5_Click()
    Username.SetFocus
    If Username = "user1" And Password = "user1" Then
    DoCmd.Close
    DoCmd.OpenForm "F_switchboard"
    Else
    MsgBox "Username and/or Password are incorrect."
    End If
    End Sub

    Since I want to distribute my application to different users, I want to add the feature for users to create their own UN and PW, because if I use the above mentioned system I will have to create UN and PW for each user and they will have to remember it always. And this application is an offline application.

  5. #5
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Why not distribute the app with one user and password already entered. Perhaps something like user name "Admin", password "LetMeIn".
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  6. #6
    ashu.doc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    124
    But then what is the use of username and password when everyone has the same?

  7. #7
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Well to get them into the app to start with, so that they can change them to their own choice.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-24-2012, 06:10 PM
  2. Replies: 1
    Last Post: 06-22-2012, 08:05 AM
  3. Users
    By Faisal6309 in forum Access
    Replies: 1
    Last Post: 03-07-2012, 04:39 PM
  4. VB Password
    By SAHeat6902 in forum Security
    Replies: 1
    Last Post: 09-30-2009, 03:13 AM
  5. Change from old password to new password
    By richy in forum Security
    Replies: 0
    Last Post: 11-17-2005, 05:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums