Locking a field... for good!

16 Sep 2007 4:12 PM

DanielWalters6

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

--
Dan Walters

16 Sep 2007 9:24 PM

Ed Metcalfe

Show quote

"DanielWalters6" <DanielWalte***@discussions.microsoft.com> wrote in message
news:D2704118-A174-4631-9FBE-985C819C8476@microsoft.com...
> 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.?
>
> --
> Dan Walters

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.