User queries and security

[allyn44]

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 spreadsheet.

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

[Keith Wilby]

<al*****@cox.net> wrote in message
news:bm********************************@4ax.com...

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 spreadsheet.

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

[allyn44]

On Thu, 9 Feb 2006 08:39:47 -0000, "Keith Wilby" <he**@there.com>
wrote:

<al*****@cox.net> wrote in message
news:bm********************************@4ax.com.. .

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.

Good!

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.

I thought so

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.

They won't see the db window and am making custom menus-also hiding
menu bars etc. All tables and stored queries will also be hidden

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 spreadsheet.

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.

YEs access security is somewhat confusing to me--but you have
answered my concerns--thank you!Keith.
www.keithwilby.com