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?
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.