Workgroups multiple databases

[Jonathan]

I have an Access 2002 application with a front end and back end database.
Both are secured. The FE is designed so the users can't escape from the
forms to native Access. The users have Read Data, Update Data, Insert Data,
Delete Data and Read Design permissions for the tables. This is so all the
forms will work properly.



I want to create a duplicate FE database for certain users such that they
can get into native Access and play with the queries and reports. But I want
the security on this database to prohibit changes to the data in the tables.
That (I assume) would mean Read Data and read Design permissions.



The question is: Do I need to create a separate workgroup with these unique
permissions? If I do that, will that in some way clash with security on the
BE database?



Any advice appreciated.

 

[Joan Wild]

I have an Access 2002 application with a front end and back end
database. Both are secured. The FE is designed so the users can't
escape from the forms to native Access. The users have Read Data,
Update Data, Insert Data, Delete Data and Read Design permissions for
the tables. This is so all the forms will work properly.

You should use RWOP (run with owner permission) queries as record sources
for forms/reports. You can then deny all permissions on the tables, and
give the appropriate permissions on the queries instead.

I want to create a duplicate FE database for certain users such that
they can get into native Access and play with the queries and
reports. But I want the security on this database to prohibit changes
to the data in the tables. That (I assume) would mean Read Data and
read Design permissions.

You can grant just this group read data/design permissions on the tables,
then.

The question is: Do I need to create a separate workgroup with these
unique permissions? If I do that, will that in some way clash with
security on the BE database?

Use your existing workgroup file, putting these users in a separate group.