Switchboard/forms only for users

E

Erik

Hi All!

I am trying to force all non-admin users to use the
switchboard and forms while not being able to open the
tables, queries, or other objects directly. I have
implemented user-level security with the help of a server-
based .mdw file and shortcuts, and it seems to doing it's
job, but unless I enable insert permissions (for the basic
users) on the tables involved in these forms, the forms
just come up blank (with no controls in them). I tried
Setting the "Run Permissions" for each of the queries
involved to "Owner's" (RWOP) - also tried giving the users
full permissions (update, insert, delete) to the queries
themselves (not the tables) - still no luck.
Please help!!

Thanks,

Erik
 

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