Security - WIF

[bmorganh]

I have created a secured database with a new wif. I am the administrator and
have no problems, but the others who are listed in the New Data Users cannot
enter data into some of the forms. I have a single table which uses one form
to populate 8 of the 10 fields and a separate form to populate the other 2
fields. The form with the eight fields can be populated by all users without
problems. However when a New Data User opens the second form to populate the
remaining two fields they are denied the ability to enter the data.

 

[Chris O'C via AccessMonster.com]

Either give "run with owner permissions" to the query the 2nd form is bound
to, or give the new data users group these permissions on the query:

1 - read design
2 - read data
3 - update data
4 - insert data
5 - delete data

Chris
Microsoft MVP