Front End / Back End Permissions

  • Thread starter Thread starter tbl
  • Start date Start date
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?
 
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
 
Back
Top