Password Protected Form Creation 1

[Kam427]

Currently, I am attempting to create a form (and various tables) which hold somewhat confidential data. Thus, I would like these to be viewable only to those who are qualified, and thus password protect these forms/tables. However, I would also like to leave 1 form which is accessible to all users (for them to input their own data).

So far, I've attempted various pieces of code in the onClick and onLoad events for the forms/tables I would like to password protect, yet I need a certain macro (which was not specified). I'm a relatively new at Microsoft Access, so I was wondering if I could get some assistance in password-protecting these forms/tables.

 

[oxicottin]

Kam427, I am currently using the example provided. It gives you 3 chances and you only have 60 seconds to get it right or it goes back to your frmSwitchboard. Good luck...

 

[ZmrAbdulla]

Did you read this?

http://support.microsoft.com/kb/207793

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[Kam427]

Thanks a lot oxicottin... I love the format of your password-protection scheme, however, I was unable to place this onto another form. How exactly should I go about inserting this?

And regarding the second reply, I have read the FAQ, but the user-level security is not really what I seek...

 

[oxicottin]

Kam, frmSwitchboard has a button that opens the frmPasswordRequired and hides the frmSwitchboard by making it visible = False but you can chang that and close that form if needed but you have to change it in a few other places as well. What I gave you is if you want certain people to access a form in this case its frmUpdateEmployees then this would either allow if the password is correct or wont if incorrect. If you want to pasword protect a button then use something like this in the buttons on click event.

Private Sub ButtonSubmit_Click()
   If Me.txtPassword = "Some Password" Then
      ' Password is correct, continue.
   Else
      MsgBox "Login Failed", vbOkOnly
      ' Password is incorrect, do not continue.
   End If
End Sub

 

[oxicottin]

Kam this would also be very helpfull... This site has some good examples!

http://www.databasedev.co.uk/button_security.html

 

[Kam427]

Thank you very much for that...

Hopefully that ought to solve that problem... the site is also very useful..

xD