Security and Permissions

[Su]

I've gone through the process on setting up different
levels of permission and security settings...for certain
objects within the database for people to see.

I would like to allow permission to open up a form but I
don't want to allow permission to access the table...but
the permission settings requires me to have the object
table - read data and design ticked for it to be possible
to read data from the form object.

Apart from hiding the table from view (which isn't very
secure) is there another way whereby I can secure the
table itself?!?

Any help would be appreciated!
Thank you!

 

[Joan Wild]

Change the recordsource of the form from the table to a query instead. You
can then set the 'run permissions' property of the query to owner.

Users will not need any permissions on the tables; you'll just need to
assign read data permission on the query instead.

 

[Guest]

Hi Joan,

I have tried that by creating a query from the table.
However when I do allow permission to read the query and
not the table with permission to the form.
The same problem arises?!?

The query is linked to the table and so it says it
requires permission to the table?!

 

[Joan Wild]

Hi Joan,

I have tried that by creating a query from the table.
However when I do allow permission to read the query and
not the table with permission to the form.
The same problem arises?!?

The query is linked to the table and so it says it
requires permission to the table?!

Did you set the RWOP property? Does the owner of the query have permissions
on the tables?

Do any of the underlying tables have 'lookup fields' in them?

 

[Guest]

Thank you so much!
It works this time!!!!

-----Original Message-----

Did you set the RWOP property? Does the owner of the query have permissions
on the tables?

Do any of the underlying tables have 'lookup fields' in them?

--
Joan Wild
Microsoft Access MVP


.

 

[XYSADASDD]

IF YOU NEED TO UPDATE DATA TO THE RECORDS YOU WILL NEED TO
ADD THIS PERMISSION TO THE TABLE IN ADD TO READ

 

[Joan Wild]

That is not the case. If you use RWOP queries, you only need to assign
permission to the query, not the underlying tables.