form Security

[Katherine]

Is it possible to password protect a form rather than the
entire Database?

 

[Gerald Stanley]

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

 

[Rick B]

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?

 

[Katherine]

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.

 

[Gerald Stanley]

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

 

[Joan Wild]

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.

See these knowledge base articles:
http://support.microsoft.com/?id=209871
http://support.microsoft.com/?id=179371

 

[Katherine]

Thank you for your help, I will try that.
Katherine

 

[Katherine]

IT WORKED!!! YAHOOOOOOOOOOOOOOO Thank You soooooo much
Gerald.