Multiple user login in one Access 2007 database

5 pts.
Tags:
Access 2007 functions
Access Database
Microsoft Access 2007
I found a lot of answers how to make a multiuser login but when count of users is known. I want to put all my users and passwords in one table and search for them. For example (I am admin with full access. I want to add a new user and give him different access. So I'll put a new record in my "Users" table with Username, Password, Access . Then in login form, I want to search this table for exact user and pass to give him access... not to write every one in code. ) I hope you understand me


Software/Hardware used:
Access 2007
Asked: Last updated:
Related Questions
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can use this code on the login button:

If (IsNull(DLookup("[EmployeeID]", "tblEmployees", "[EmployeeID] ='" & Me.USERLOGIN.Value & "' And EmployeePassword = '" & Me.PASSWORD.Value & "'")))

Then:

MsgBox "Incorrect ID or PASSWORD", vbInformation, "worng LOGIN"Me.USERLOGIN = Null Me.PASSWORD = Null
Else

And after else you open the target form this will do:

  • [EmployeeID]=is the name of the username field in the access table
  • tblEmployees=is the name of the access table
  • Me.USERLOGIN.Value=is the name of the user name field in the login form
  • EmployeePassword=is the name of the password field in the access table
  • Me.PASSWORD.Value=is the name of the password field in the login form

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: