Enter Microsoft Access database with login screen

Asked By malakasilon 0 points N/A Posted on - 08/19/2011

I have created a Microsoft Access database using Microsoft Access 2007. I created a user table with username and password. Now I want to enter using that username and password.

 

How can I make a login table using Microsoft Access 2007? I want these to happen: if the username and password match, it goes to the next step, but if they don't it returns to the login page with an error message.

• Status: Open
• Question Views: 1985
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By saadqureshi 0 points N/A #116139

Enter Microsoft Access database with login screen

Here is the way of making login page when username and password match, the next screen will appear.

Creating a login & password protection.

• Step 1: Open your Microsoft Access and choose the forum.
• Step 2: After the choosing the forum make shape for your login forum.
• Step 3: Make two rows for username and password where the user enter his username or password.
• Step 4: Choose buttons from your left hand for login or cancel.
• Step 5: Click on buttons and set up this setting to write names on it.
• Step 6: Choose forum source code panel to enter the code.

Here is the code of login page:

username.setFocus
If Username = "user1" And Password = "user1" Then
MsgBox "Access Granted", vbInformation, "CD Shop"
MsgBox "Welcome", vbInformation, "CD Shop"
DoCmd.Close
DoCmd.OpenForm "F_Switchboard"
Else
MsgBox "Please re-enter your Username and Password."
End if

• Step 7: Click on debug and run.

Note : "user1" is your username or password.

Thanks.

About saadqureshi

Questions
1

Answers
3

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/19/2011
• Question Category: MS Access