F
Firman
I just read how to prevent users from updating directly
to
forms or query, faq #25 in
http://support.microsoft.com/default.aspx?
scid=/support/access/content/secfaq.asp#_Toc493299694 but
it is confusing for me for the following step:
1. Log on as a member of the Admins group. (Admin1, owner
of the database)
2. Create a query that accesses the tables and has its
RunPermissions property set to Owner's rather than User's.
This will provide sufficient rights to users to read, add,
change, and delete data. At this point all users and
groups, except for Admins members, will have no access to
this query.
At point #2 I try from Tools | Security | User and Group
Permission,
and click Groups, click Group1 (in User/Group name) and
assign all permission to the table and query to OFF
Is it right?
I try to the rest of the code, but the forms can not be
opened because no permission to the table. I try with
debug, but the forms is blocked before firing event
activate-form.
Would you please help me with more clear steps/codes?
Thank you.
Firman.
to
forms or query, faq #25 in
http://support.microsoft.com/default.aspx?
scid=/support/access/content/secfaq.asp#_Toc493299694 but
it is confusing for me for the following step:
1. Log on as a member of the Admins group. (Admin1, owner
of the database)
2. Create a query that accesses the tables and has its
RunPermissions property set to Owner's rather than User's.
This will provide sufficient rights to users to read, add,
change, and delete data. At this point all users and
groups, except for Admins members, will have no access to
this query.
At point #2 I try from Tools | Security | User and Group
Permission,
and click Groups, click Group1 (in User/Group name) and
assign all permission to the table and query to OFF
Is it right?
I try to the rest of the code, but the forms can not be
opened because no permission to the table. I try with
debug, but the forms is blocked before firing event
activate-form.
Would you please help me with more clear steps/codes?
Thank you.
Firman.