Allow Read-Only User To Update One Field

  • Thread starter Thread starter Toby Young
  • Start date Start date
T

Toby Young

I would like to allow one of my read only users to be
able to update one field on a form.

The user is set-up as a read only user for all objects,
but I would like them to be able to update one single
field only. I don't want to use a subform with different
permissions to the underlying table.

Is this possible? Any help would be greatly appreciated.

Thanks in advance.
 
Lock and disable all the controls except the one textbox that you want the
user to be able to update.
 
I guess I didn't word things correctly:

This user (User 1) is not allowed to update information
in the underlying table (Security Wizard). Other users
are allowed to update all fields. I would like to make it
so that User 1 can update one field only, while the rest
of the users can still update all fields.

Hopefully this is easier to understand.

Thanks for your help.
 
On the form's OnLoad event, disable the controls if it's User1; otherwise,
leave then enabled.

I have not used the Security Wizard, so am not familiar with it. Is this
wizard preventing you from making one field available?
 
Back
Top