Table Permissions and Security

  • Thread starter Thread starter brent
  • Start date Start date
B

brent

Good day,

I am looking for a way to make both tables and their links read only to
the user but have full admin with the forms and code.

I have a database with backend holding master tables of course and a
front end with forms reports, queries macros and modules.

I want to know if anyone has found a way to both protect current items
from deletion and editing but allow the creation of new adhoc reports
and queries.

In addition to this I wish to allow the visibility of the tables for
data mining purposes.
The user wants to be able to create ad-hoc queries and reports and be
able to save them but not edit/add/delete data in the tables. There
are forms that will allow the user to do this and verify the data
before adding to the table.

With the Access Security I can either allow read / edit / add / or full
access but as far as I can determine, this is for all objects.

Any assistance will be greatly appreciated.

Thank you,

Brent Webster
 
Good day,

I want to know if anyone has found a way to both protect current items
from deletion and editing but allow the creation of new adhoc reports
and queries.
Click to expand...

You can protect your application using security, and give them a new
database, linked to your tables. They can make all the adhoq
queries/reports they like in this mdb.
In addition to this I wish to allow the visibility of the tables for
data mining purposes.
The user wants to be able to create ad-hoc queries and reports and be
able to save them but not edit/add/delete data in the tables. There
are forms that will allow the user to do this and verify the data
before adding to the table.
Click to expand...

You can deny all permissions to the tables, and provide a RWOP (run with
owner permission) query for each table. Then set read data permission on
these queries. Provide the adhoq query with the table links and these RWOP
queries. They'd base all their querying on the RWOP queries. They'll be
restricted to reading data only, since that's the permission on the RWOP
query.
With the Access Security I can either allow read / edit / add / or
full access but as far as I can determine, this is for all objects.
Click to expand...

Not at all true. In fact you would go through the process of
adding/removing the permissions you want on each and every object.

When you implement security, be sure you follow every step. I've outlined
them in detail at
www.jmwild.com/AccessSecurity.htm
 
Back
Top