I am trying to secure one of my forms so that only nurses can access it and edit it. I used the code found here...
Private Sub Form_Open(Cancel As Integer)
Dim pwd As String
pwd = InputBox("Enter the Password")
If pwd = "Your Password here" Then
MsgBox "Password Correct"
MsgBox "Incorrect Password!!"
...which works but the only problem is that nurses will be opening this form up multiple times in a session and I don't want them to enter the password everytime. Is there something that I can add to this code where they only have to enter it once during the time that they have the database open.
I have another question about setting up a secured database. The program is currently in Access 2003 but in the next few months they are switching over to 2007. Will the security workgroup still work if I add that piece to my database? I would rather do that so that I can give certain people views of the data without the ability to edit.