Password Protect a Control - Access 2007

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

Guest

Is there a way to password protect certain elements or fields?
I have a form that has a couple fields that I don't want users to be able to
alter the contents. One is a date. They need to be able to change other data
so I don't want the form to be read only.
 
Is there a way to password protect certain elements or fields?
I have a form that has a couple fields that I don't want users to be able to
alter the contents. One is a date. They need to be able to change other data
so I don't want the form to be read only.

Hi Tim,
Yes you can lock down any field by going to its Properties, under the
Data tab, find LOCK and set to Yes. Note this will stop anyone from
editing or changing this field, but only this field. I do the same
thing with the autonumber, which I use as a reference for the record.
I want everyone to see it but no one to change it.

db
 
Don Barton said:
Hi Tim,
Yes you can lock down any field by going to its Properties, under the
Data tab, find LOCK and set to Yes. Note this will stop anyone from
editing or changing this field, but only this field.

Actually what you are doing is setting the locked property of a *control* on a form. That only stops the person from changing the contents of that control. It won't stop them from changing the field (say from another form, query, or table).
I do the same
thing with the autonumber, which I use as a reference for the record.
I want everyone to see it but no one to change it.

This is one case where you wouldn't need to set the locked property. It isn't possible to edit an autonumber field.
 
Thanks for the lock suggestion but unfortunately that would create another
problem - I (as an administrator) need to be able to enter a value in that
field.
If I lock the field I won't be able to change the contents either.
The database is packaged as an application so unlocking when I need
to enter data is not practical either. That's why I suggested a password.
Any other ideas?


Thanks!!!!
 
Back
Top