Security

[jbarna]

Help!!!!!!!!!
I am a newbe and i have crated a db to track prduction my question is
very general. I do have user level security but if i stop access to a
table for a usere they cant use the forms or querys assocciated with
that table.
I Is there a way to lock the tables so users can only interact with
them thought forns?

Thanks in advance.

John B.

 

[Guest]

John:

Base your forms on queries whose Run permissions property is set to Owners,
or which include WITH OWNERACCESS OPTION in the SQL. The latter can be used
with both saved queries and SQL statements in code, while the former can be
used only with saved queries. The user will then have access to the queries
and any forms based on them as though they had the owner's permissions. You
can thus, if necessary, limit the columns from the table which the user can
access, or restrict the access to rows which match criteria in the query.

For a full explanation of this and other security matters take a look at the
following link:


http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp


Ken Sheridan
Stafford, England

 

[Joan Wild]

You can deny permissions to the tables, and use RWOP queries for all data interaction. Read about RWOP (run with owner permissions) at
www.jmwild.com/RWOP.htm