Front End / Back End Permissions

T

tbl

How should permissions be set for the Data Entry group with
respect to front end and back end.

Should the back end have no permissions for anyone besides
the admins group?
 
J

Joan Wild

The users will need Open Permission on the backend and frontend Database
Object. You can remove all permissions on the backend tables and the
frontend links, and use RWOP (run with owner permissions) queries for all
data interaction. See www.jmwild.com/RWOP.htm for more information on RWOP.

To refresh/relink the tables, there are various methods, each requiring
different permissions. There is information/code in the security FAQ that
covers this.
http://support.microsoft.com/?id=207793
 

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

Shared Link is showing empty notebook 1
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
VBA concatenate ranges into a new document 0
Admin Privileges for Others not Working 0
Word macro that can call cells out of Excel for a find and replace 0
Clearing combo boxes and a text box 2
Making a macro only work on certain files 2

Top