restrict users from tables but allow access to forms

[Guest]

I want to restrict users from updating, input, or delete from the tables and
only allow these functions using forms. Bascially I do not want any users in
the tables. I have tried multiple combinations of the user security features
but if I allow read only to the table - when the user opens the form and
inputs the data and then clicks on the button to run the update query - it
fails due to the security setting. If I allow update then the user can open
the table and update which I need to prevent.
Any suggestions?
TIA
Cindy

 

[Joan Wild]

You can remove all permissions from the tables, and use run with owner
permission (RWOP) queries for all data interaction. Read about it at
www.jmwild.com/RWOP.htm