Blocking Access to the back end of a split database

M

Mark

Is there any way to block a group of users from viewing
data in the back end of a split secured database? The
reason I ask is this: couldn't users that have permissions
to create new records in a table - but only through a form
with specific controls set - bypass the controls by going
to the tables in the back end?

Thanks if you have an answer.

Mark
Ontario
 
T

TC

You can do this by ensuring that *all* access from the FE to the BE tables
is via so-called "Run With Owner Permission" (RWOP) queries. With that
approach, you can set things up so that the users have *no* access directly
to the BE tables, even though they can access those tables via FE forms &
reports.

HTH,
TC
 

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

How to split Front end/Back end 7
Securing a split Access database 2
Converting split database 3
Front End Back End Security 1
front end and back end security 1
Securing the back end of the database 1
Secure back end database 1
Securing the Back-End 2

Top