Table permissions when updating to a view

[edwilli]

I have a form whose record source is a view. As long as the user is only viewing the data, I don't need to assign any permissions to the underlying table. However, if I want to insert or update to the view, the user needs the same permissions on underlying table. Is there a simple way around this security flaw?

Eric

 

[Nowell]

No way round, and I would not say it is a flaw it is just extra security. If there are no permissions on the table it could be maniplutated by anyone who knows how to qrite SQL commands...not good.