Blocking Access to the back end of a split database

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