asked on

Microsoft Access forms and passwords

Ok i Have a access database where i have people inputting data into a form. I locked 2 of the fields. Only someone with a password can enter into those fields. What I would like is if the user clicks in those fields then a password prompt comes up and they will be able to enter or change the data in those fields? Can that be done?

thanks

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

PatHartman

This prompting will eventually annoy the users. Especially if you are going to do it once for each field. A better design would be to have all users log on. Assuming the login is valid, the login form hides itself rather than closing and opens the main menu. Then in the BeforeUPdate event of EACH secured field, check the security level on the login form and either allow or deny the change. Only one password entry will be required regardless of how many secured field on secured records will be updated.

If Forms!frmLogin!txtLevel > 7 Then
Else
    Msgbox "You are not allowed to change this field.",vbOKOnly
    Me.Thisfieldname.Undo
    Cancel = True
    Exit Sub
End If

Open in new window

This requires a little more sophistication than you are asking for but it will not annoy the users and it can be expanded. To implement, create a table with a userID, password, and security level. You will need a maintenance form that is only valid for users with a very high security level.

jpb12345

ASKER