Locking a field... for good!

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

Guest

Is it possible to lock a field forever? So that no-one can modify it - Even
if they have Admin rights?

I would like to store some DOBS and National Insurance numbers which NEVER
CHANGE, unlike Surname etc.

I would like to build a system, that once a DOB has been confirmed three
times by the employee, it's set in stone. And cannot be changed by system
administrators.

If there isn't a way of doing this in Access, is there a way, which I can
after confirmation add it to a text file, which is called by Access, in a
read-only format?

Obviously I would need to think of some way to encrypt the textfile.?
 
DanielWalters6 said:
Is it possible to lock a field forever? So that no-one can modify it -
Even
if they have Admin rights?

I would like to store some DOBS and National Insurance numbers which NEVER
CHANGE, unlike Surname etc.

I would like to build a system, that once a DOB has been confirmed three
times by the employee, it's set in stone. And cannot be changed by system
administrators.

If there isn't a way of doing this in Access, is there a way, which I can
after confirmation add it to a text file, which is called by Access, in a
read-only format?

Obviously I would need to think of some way to encrypt the textfile.?
Click to expand...

Dan,

Yes, and no.

No, it isn't possible to lock the field itself - Access does not allow
setting of security at the row/column level - only at table level.

However as your users should not be entering data directly into a table, it
would be possible to lock the relevant form control(s) to prevent editing of
the value once it has been entered.

As far as Admin users are concerned you should always have *somebody* who
can edit the values, even if it is only you...

Ed Metcalfe.
 
Back
Top