Username and password table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a table that holds all the usernames and passwords. Then i
want to make a form that opens with the database that can verify the user. I
know access has it's own security system, but is there a way to do it like
this?
 
Bexar1 said:
I want to make a table that holds all the usernames and passwords.
Then i want to make a form that opens with the database that can
verify the user. I know access has it's own security system, but is
there a way to do it like this?
Click to expand...

Sure you can do it, but without Access built in security any one of your
users will be able to look directly at the passwords table making it pretty
useless.
 
Bexar1 said:
So how would i put my plan into action regardless?
Click to expand...

Have two TextBoxes on the form named "UserName" and "Password". The user
fills out both then presses [OK] button. The code behind that button is
like...

If DCount("*","PasswordTable","UserName = '" & Me.UserName & "' AND Password
= '" & Me.Password & "'")= 0 Then
MsgBox "Invalid User Name and/or Password"
Else
DoCmd.OpenForm "YourMainMenuName"
DoCmd.Close acForm, Me.Name
End If

You would want to set the InputMask property for the Password TextBox to
"Password" so it will only display asterisks as they type. You could get
fancier and close the application after more than a certain number of bad
attempts are made.

Trust me though...anyone with just a smattering of Access knowledge will fly
past this "barrier" with no trouble at all.
 
As in turning on the Hidden property of the table? Anyone can set Access to
display hidden obejcts. And you can import hidden tables to other databases
even without unhiding them.
 
Rick said:
Sure you can do it, but without Access built in security any one of your
users will be able to look directly at the passwords table making it pretty
useless.
Click to expand...


If he had to, he could hash the passwords using a cryptographic 1-way
hash (eg. MD5). Then, viewing the password table would not reveal the
plaintext passwords.

TC
 
Back
Top