What permissions do I need to do .Edit?

[Stapes]

Hi

I have created a database with user level security, split into fron
end and back end. One form has a process which opens the table
"OrderItemComponents" and the tries to use .Edit
At this point I get a messaeg saying I do not have the required
permissions.
I have checked the Security > User and Group Permisssions for the
table in both the front end and back end. Both have all the boxes
ticked. What more does it want?

Stapes

 

[Stapes]

Hi

I have created a database with user level security, split into fron
end and back end. One form has a process which opens the table
"OrderItemComponents" and the tries to use .Edit
At this point I get a messaeg saying I do not have the required
permissions.
I have checked the Security > User and Group Permisssions for the
table in both the front end and back end. Both have all the boxes
ticked. What more does it want?

Stapes

I found the answer to this. The error messages are misleading, leading
me to think I needed to set permissions to a table. In fact, they
refered to a query using the table.