Field Security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to secure one field, I have a field where a manager will sign
off as approved for an engineering change request (ECR) and only need to
prevent someone from putting in a signature I know I could do a separate
form and startup screen for managers, but that is just one more thing to keep
track of when updating/changing the database and this is a major change to
our ECR process and is a work in progress.
 
Access has no in-built method to secure a field (it stops at table-level
security), but there is no reason why you can't write your own to simulate
"field-level security".

See (in this newsgroup)
"Field level security solution"
15/7/05, poster "Leif"

RWOP queries can limit the viewability etc of fields (by making fields
available or not to selected users). Search MS-Access help on "owner
permissions" or something for the low-down on RWOP queries.

I guess there are other methods too, anything you can think to do with VBA
code basically.

(User-level security is a pre-requisite for most user-based different
presentations, never mind password cracking programs which is a separate
issue. If you want only the "Manager's Group" to sign records off, show a
"signature field" on the form and allow them to click it to automatically put
in the "CurrentUser()". For "ordinary users" don't even display the field or
display it in "grey". If the field is already filled-out, allow only the
CurrentUser() whose name already matches the field to change it. Since the
database might get quite old, and people come and go, automatically store a
date-stamp as well. For the "signature", as against the whole record. Which
leads onto, if someone has signed it off, you probably want to (in your form)
make that specific record "read-only" for the "average user", and that can be
done via VBA by intercepting some of the form's "events" [wouldn't like to say
which event is best without current testing, there's a lot of trappable
events])

This is approximately what you have to do.
Chris
 
Back
Top