form Security

  • Thread starter Thread starter Katherine
  • Start date Start date
At the simplest level, you can code a form's Open
eventhandler to ask a user to input the password and to
cancel the operation if the wrong password is submitted.
If you have a number of forms that need to be protected,
you should look at Tools->Security-> User and Group
Permissions facilities.

Hope This Helps
Gerald Stanley MCSD
 
It is, but you have to come up with a way to do it through code.

Another way is to set up user-level security and then you can decide who can
and can't access the objects in your database based on their logon.

Rick B


Is it possible to password protect a form rather than the
entire Database?
 
It is just one form. Can you give me an example of the code
I would need? I am not code literate I am sorry to say.
 
Something along the lines of

Private Sub Form_Open(Cancel As Integer)
Const strFormPassword As String = "Password"

If InputBox("Please Enter Password") <> strFormPassword Then
MsgBox "Password Incorrect", vbOKOnly
Cancel = True
End If

End Sub

You had best read up on Access security as, unless you take
measures to protect the form and its code, it would not
take too much effort for anybody to see what the password was.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top