how to forbid inserting data from tables

R

rocco

Hello,
I would like to forbid data enters from manipulating data from tables. I
want that any action on data is done through forms.

What's the best way to manage this issue?

thanks,
Rocco
 
R

Rick B

You would take away their access to the tables. You would create saved
queries (and not give them any access to those queries). You would set the
query property to "run with owner's permission". You would then base your
forms off of those queries.

Of course, user-level security must be in place to do this.

Rick B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top