Simple Problem

[newcome]

Hi, All,

I want to asign a password for user to open the form, but I don't know how to asign password to user and where I can store password??

The following are my codes:

Private Sub Form_Open()

Dim strPsd as String
strPsd = InputBox("Please enter the password:&quot
IF strPsd <> &quot;Your Password&quot; then
Cancel = -1
End If
End Sub


Your suggestion will be very helpful. Thanks

Lynda

 

[THoey]

Lynda,

First I will mention that Access has a security that you can enable. I haven't used it, but there are several FAQ's that could help you out.

Other than that, you could create a table with logins and passwords and then query against that when they go to open the form. But you will still have to &quot;protect&quot; that table somehow to keep people from just adding creating their own login.

Hope that helps... Terry M. Hoey