Password Protect a Control - Access 2007

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

 

[Don Barton]

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

 

[Joan Wild]

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.

 

[Guest]

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!!!!

 

[Joan Wild]

There is code in the security FAQ you can use to determine if a user is a member of the Admins Group. In the open event for the form, you can lock/unlock that control based on group membership.

Security FAQ: http://support.microsoft.com/?id=207793

 

[Guest]

Thanks Joan!

That sounds exactly what I am looking for. I will check it out.

-Tim