User queries and security
- From: allyn44@xxxxxxx
- Date: Wed, 08 Feb 2006 23:28:25 -0700
HI--a simple question about access security--am having brain lock--if
I make queries read only to a chosen user group (as defined by access
security) will they stil be able to open forms based on sql statements
in the Record source property of the form?
I have most of my forms based on SQL statements in the record source
property of the form (drawing from more than one table)--as I
understand these they are not stored queries?
So I would need users to be able to enter data based on the REcord
source SQL but not let them change data through any queries.
My plan for users needing reports is to create a search form using
unbound fields that users can then select the fields they want, and
parameters, dump it all into a sql staement, then throw it out to a
report or excel spread***.
So when I ship this database I don't want to give users any access to
queires at all-but am not sure if this will affect the forms above or
my unbound search form.
Thanks
Bob
.
- Follow-Ups:
- Re: User queries and security
- From: Keith Wilby
- Re: User queries and security
- Prev by Date: Re: Seeking way to shorten this little code snippet...
- Next by Date: Advice: Export to excel causes access to hang.
- Previous by thread: Data Access Pages
- Next by thread: Re: User queries and security
- Index(es):