The help file mentions this, but it only mentions Make Table and Append
queries. I haven't tried it with a Select query.
(from the help file)
WITH OWNERACCESS OPTION Declaration
In a multiuser environment with a security-enabled workgroup, use this
declaration with a query to give the user who runs the query the same
permissions as the query's owner.
Syntax
sqlstatement
WITH OWNERACCESS OPTION
Remarks
The WITH OWNERACCESS OPTION declaration is optional.
The following example enables the user to view salary information (even if
the user does not otherwise have permission to view the Payroll table),
provided that the query's owner does have that permission:
SELECT LastName,
FirstName, Salary
FROM Employees
ORDER BY LastName
WITH OWNERACCESS OPTION;
If a user is otherwise prevented from creating or adding to a table, you can
use WITH OWNERACCESS OPTION to enable the user to run a make-table or append
query.
If you want to enforce workgroup security settings and users' permissions,
do not include the WITH OWNERACCESS OPTION declaration.
This option requires you to have access to the System.mdw file associated
with the database. It is useful only in security-enabled multiuser
implementations.
----------------------------------------------------
You can also do this by opening the query in design view, opening the
query's Properties, and set the Run Permissions property to Owner's. The
help file article associated with this property states, "You can use the
RunPermissions property in a multiuser environment with a security-enabled
workgroup to override the existing user permissions. This allows you to view
a query or run an append, delete, make-table, or update query that you
otherwise wouldn't have permission to run. For example, as a user, you may
have read-only permission for queries, while the owner of the queries has
read/write permission. If the owner sets the RunPermissions property to
specify the owner's permissions, you can run an append query to add records
to a table."
The "view a query" statement could be a Select query or it could mean that
you can view the SQL but can't change it. If it does mean viewing the output
of a Select query, whether or not it will also let you make changes to the
data, I don't know.
--
Wayne Morgan
MS Access MVP
"Kurch" <ku******@mac.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...
Hello,
I have an Access file saved on my company server.
Is it possible to allow selected people within my network to access a
query that I've written and allow them to read and write changes to the
cells in this query and not be able to read/write data in the master
table?
