Read Only Table

R

Rick B

Generally, users should not have access to the tables at all. They should
be working in forms.

You can take away all access from a table by a user. You can create a saved
query that pulls the data you need from the table and set that query to "run
with owner's permission". You can then base your forms on that query and
give the users the appropriate access. This keeps them from messing around
in the table and bypassing all the security you have built in your form.

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