Security / User Access

[Mikey C]

I am creating workgroups to ensure that everyone does
not kill my database. However, for some reason the only user group
that can actually run a query in the applet (see below message) is
Admins. I have even
tried giving full admin rights to all objects to all groups and they
still cannot run the queries. I really need these users to be able to
design, create, run and delete queries but unable to add, edit or
delete data in the main tables.

Everything is working as planned except for access to this one function
- I'm stumped!!

Each time a user other than admins logs-in they receive the following
error message:


Error in cmdReport_Click

3033: You do not have the necessary permissions to use the 'MSysTables'

object. Have your system administrator or the person who created this
object establish the appropriate permissions for you


(I can't even find the 'MSysTables' object anywhere in the database and

it is definitely not listed in any of the permissions lists!!)


Any help will be much appreciated


(Copy of previous reply)

Quote from Duane Hookom

You might want to consider the Query By Form applet at
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DH%2...



***FEATURES***


The DH QBF is a complete query by form applet that can be easily
integrated
into any existing Access application. Typically, the functionality
provided
by DH QBF can replace many "canned" reports. The developer imports
several
forms, tables, a query, and a report from the DH_QBF.mdb, creates some
master queries, and deploys.


The developer creates one or more master queries that join tables,
alias
field names, create calculated columns, etc. The users can then select
a
master query (datasource) from a drop-down and then select up to 30
fields
from the master query. Users can define sorting and criteria as well as

grouping and totaling. All of this "design" information is stored in
two
tables for re-use.


The results of the queries are displayed in a datasheet subform
contained in
a main form. The main form has options to send/export the records to
print,
Word table, Word merge, Excel, HTML, CSV, Merge to Report, or a graph.
Most
formats allow he user to automatically open the target application. The
Word
merge process will open a new Word document and link to the merge
fields.

 

[Joan Wild]

I really need these users to be able to
design, create, run and delete queries but unable to add, edit or
delete data in the main tables.

Your best bet is to remove all permissions from the tables. Create RWOP
(run with owner permissions) queries for data interaction.

You could give these users a separate frontend, linked to the backend
tables. Remove all permissions on the tables in the backend, and create
some RWOP queries (one for each table) in this adhoq frontend. Put Read
Data permissions on the RWOP queries. The users will need to create all
their queries based on the RWOP queries. They'll be limited to just reading
data. If you want them to be able to insert/update data in their queries,
you'll need to add those permissions to the RWOP queries.

Each time a user other than admins logs-in they receive the following
error message:

Error in cmdReport_Click

3033: You do not have the necessary permissions to use the
'MSysTables'

See http://www.jmwild.com/MSysTables.htm
sounds like you may be modifying the SQL property of a saved query. Users
need modify design permission on that query.