Workgroup Password on Form

[bob bisquick]

I have a database and security is established using a workgroup... no problem. I have a Set Up form in the database that I want to have extra security, not because the user shouldn't be able to change the form, but there are consequences if they do, so I want the database to re-ask for the workgroup password as an extra precaution. Is this possible?

 

[jdjewell]

why not use vba?

In the event that would be updating the database (either Click -- button -- or LostFocus -- most other controls), present the user with a warning message:

If vbYes = msgbox ("Are you sure you want to do this?", vbYesNo, "Security Check") then
     Go ahead and update code
Else
     txtBoxWithValue2Delete.value = ""
End If

Cheers!