how to forbid inserting data from tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
How to Populate Data from a table to another 0
How to forbid opening subform 1
Putting restrictions in a split database 1
Can I forbid updates on just one field and not to forbid inserts 4
Form data property vs Control data property 1
How to forbid printing (Ctrl+P) and other key shortcuts in MDE 2
How to Create a Macro to Import External Data 0

Back
Top