Re: User queries and security

<allyn44@xxxxxxx> wrote in message
news:bmnlu1hklup8kalmqicl7k2shga8f6b5b6@xxxxxxxxxx
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?

Yes, provided that they have permissions to open 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?

That is correct. A stored query will appear in the query window.


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.

You shouldn't allow your users to see even the database window IMO. Hide
everything under the bonnet (hood) from them and apply your security by
providing them with forms and custom menus to mamipulate the data.


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.


I'm not sure I understand your concerns. Have you read the FAQ on security?
If you haven't then I highly recommend that you do. There's a link on my
web site.

Keith.
www.keithwilby.com


.