Run Permissions

[jbkirby via AccessMonster.com]

What do I need to use in a multiuser environment for my front-end and backend
objects, owner's permission or user's permission and why?

 

[Keith Wilby]

What do I need to use in a multiuser environment for my front-end and
backend
objects, owner's permission or user's permission and why?

Homework time again? Can you be more specific? Are you talking file
permissions of RWOP queries?

Keith.

 

[jbkirby via AccessMonster.com]

i guess? In MS Access menu, there is tools>options and in the tables/queries
tab, there is run permissions. How do I use this for security and how is this
related to user and group permissions? I have an application whose backend is
in a server and I want to restrict other users from updating records from
certain tables.

 

[Keith Wilby]

i guess? In MS Access menu, there is tools>options and in the
tables/queries
tab, there is run permissions. How do I use this for security and how is
this
related to user and group permissions? I have an application whose backend
is
in a server and I want to restrict other users from updating records from
certain tables.

That setting is used in conjunction with User-Level Security to allow
queries to be run with the query owners permissions. So if the owner has
full update permissions to the query, then anyone with permissions to open
that query will inherit those permissions. See the FAQ on ULS for more
details, there a link to it on my web site.

Keith.
www.keithwilby.com