How to use password in MS Access

Asked By Donnaa Gordon 50 points N/A Posted on - 05/15/2012

I want to use a button for password protecting method. Tried out the following code.  But it isn't working properly.

Could you please specify the bugs and could you please handle these?

Thank you million times.

If InputBox("password") = "thepassword" then
Docmd.OpenForm formname
Else
MsgBox "You are not authorized!",vbOKOnly
End if
Private Sub Open_Activities_Menu_Click()
If InputBox("Enter password") = "111111" Then
DoCmd.OpenForm Activities_Menu
Else
MsgBox "You are not authorized!", vbOKOnly
End If
End Sub
The issue is the DoCmd line where I get a message
Run-time error '2494':
The action or method requires a Form Name argument

Your help is very much appreciated,

Thank you.

• Status: Open
• Question Views: 1036
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Milton galo

Go To Solution

Best Answer

Best Answer

Answered By Milton galo 0 points N/A #144955

How to use password in MS Access

Hi

Here is the solution for your problem

Just write the code as follow assuming the command button name is Command42

—————————————————

Private sub command42_Click()

 On Error Goto Err_command42_Click

      Dim stDocName As String

      Dim stLinkCritieria As String

If input ("password") ="thepassword" Then

        stDocName="Form Name"

        DoCmd.OpenForm stDocName,,,stLinkCriteria

Else

        MsgBox "You are not Authorized", vbOKOnly

End If

Exit_Command42_Click:

       Exit Sub

Err_Command42_Click:

      MsgBox Err.Description

      Resume Exit_Command42_Click

End Sub

—————————————–

and It will work with you 

the idea here is to create a button to open form normally using the wizard then you do some changes on it to put the condition of password and make the restriction

About Milton galo

Questions
2

Answers
3

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/15/2012
• Question Category: MS Access

Answered By wirt yule 50 points N/A #144957

How to use password in MS Access

 

I use MS Access a lot but i want to keep my files safe and locked. So i tried putting passwords but it didn’t work. I really needed a solution for this problem because my files need protection from my "nosy" brother. Thanks to techyv.com and the expert for solving the issue. You have literally saved my life. Thank you very much. It works 100% now!

About wirt yule

Questions
31

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/20/2012
• Question Category: MS Access