Password protected form

[Guest]

How do I add a password protected form? I don't want to set up user
accounts, I just want to add a password to enter a specific form. Can it be
done???

 

[Jeff Conrad]

in message

How do I add a password protected form? I don't want to set up user
accounts, I just want to add a password to enter a specific form. Can it be
done???

Access User Level Security will provide the *best* security for you, but
if you just need something simple for a single form and/or report you could
try these Microsoft KB articles:

http://support.microsoft.com/?id=209871
http://support.microsoft.com/?id=179371

 

[Rick Brandt]

How do I add a password protected form? I don't want to set up user
accounts, I just want to add a password to enter a specific form.
Can it be done???

In the OpenEvent of the form...

If InputBox("Enter Password") <> "YourPassword" Then
MsgBox "Wrong Password"
Cancel = True
End If

If you are not distributing as an MDE then anyone will be able to go into
design view and see the password though. Also there is no way to get a
password mask (asterisks) with an InputBox().