Help Required in MS Access - User Authentication/Login & Password Verification

[xcessminds]

I have a group forms in a module that requires User Authentication through
Login and Password. For this I have designed a Form with two fields Text1 and
Text2, my first Question is:
How can I make Text2 as Password text fields i.e. field should show '*' instead of
Plain Text in the field?
My second Question is:
How can I verify the User Inputs to login & password saved in a table?

I need an urgent reply.

 

[Kempes]

For *, use the input mask wizard and choose password.

For password authentification, can you elaborate on how your security is set up?
The best way I believe to do this is by using a workgroup file to launch permissions against the database. This will give you the option to assign users to groups and allocate privelidges againsts that group or user. It also has the password option which launches on database load along with their allocated username. (Password already set to ***** when keying in).

regards
kempes

 

[xcessminds]

Thanks kempes for your urgent response

Actually I have a Form with two text fields one for User Login and other for User Password.

Table: Login_Info
Column1: Login_ID
Column2: Password

I want to match the values entered in two fields on Click of LOGIN button, i know it is just a simple way of verification but i need this. Here is my Command16 (Login Button) Code, kindly suggest any Lookup that can do this:

Private Sub Command16_Click()
On Error GoTo Err_Command16_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Physician Home"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command16_Click:
Exit Sub

Err_Command16_Click:
MsgBox Err.Description
Resume Exit_Command16_Click

End Sub

 

[Kempes]

Ok. So I Guess your table looks something like this then.

LoginID Password
1 blue
2 yellow
3 green
etc

OK, I have tested this and it seems to work.
On your form, add 1 combo box and 3 text fields.
Set the 3 text fields to visible = no.
your combo box should be unbound, and show a list on login ID's from your table.
set one of the hidden text fields control source to your login ID.
set another to the password.
Keep the third as unbound.

With your combo box, go to events then after update

Private Sub Combo0_AfterUpdate()
Me.loginID.Visible = True
Me.loginID.SetFocus
DoCmd.FindRecord Me.Combo0.Value
Me.Passwordunbound.Visible = True
Me.Passwordunbound.SetFocus
Me.LoginID.Visible = False

Me.Refresh

this will show a password box (which is unbound).

Add a command button that will appear once a value is keyed into the unbound password field so that once a password is entered, the button will appear.

Go to on click event

Private Sub Command8_Click()
If Me.passwordunbound.Value = Me.password.Value Then MsgBox "yep" Else MsgBox "NOPE"

End Sub

obviously, change the code to open a form or whatever you need it to do.

hope this helps

 

[scouser]

Example

I have posted an example database, hope it helps.

The password is set to: 123
Phil.

 

[SKJ]

Re: Help Required in MS Access - User Authentication/Login & Password Verification

Scouser/Phil,

Could you please upload your full example here. I opened your older(2007) zip of this post and is very useful to what I am looking for. Please see my today's post for details.
I am using MS access 2010.

Thanks!
SKJ