I have Password protection on the
entire Access Database, but what I
would really like is even more specific
protection. On one form I ask for
signatures. I would like to know that
if anything is put into that box that
the owner had to use his password
to put it there. Only one person could
enter anything into that specific cell
in the form. Is it possible?
The overall database password is easy enough to break that experienced
developers know it just gives a false sense of security. Access User and
Group Level security is more robust, requiring each user to log in with
their own userid and password, but it is not foolproof.
Even Access User and Group Security does not extend below the Access object
level.
However, if you emphasize the need for security, so that users do not share
their userid and password, that can likely serve the purpose you desire. At
the simplest, you can put a check box for "approval" on the form, and, if
that is checked, record the user's id, available from built-in function
CurrentUser in a hidden Field.
If only a subset of users are allowed to "approve", you can create a Group
called Approvers, include those users in the Approvers group, and only give
Approvers permissions on the Approval form.
I caution, however, that User and Group Level Security is not a trivial
subject. It requires considerable study and practice, and "is not for the
faint of heart".
