Denied access to the tables

N

Neo

Hello Everyone,
I wanted to deny access to the tables for my users. I
want them to have read,insert, update permissions for the
forms but i don't want them to be able to click and get
into the tables because the control is only limited. is
there any way i can deny access to the tables? please
help!!
 
J

Joan Wild

You need to implement Access user security. Download and study the security
FAQ available at
http://support.microsoft.com/?kbid=207793

You'll be able to remove all permissions from the tables, and set up RWOP
(run with owner permission) queries as record sources for your
forms/reports.

Details in the FAQ.
 

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