Re: msystables? / users saving their own queries?

>> I want the users of this system to be able to save custom queries
>> based on the permissions that they have. So the user can take the
>> queries and/or tables that they have permission to and run and save
>> a query. However, the users can create a query and run it, but when
>> they try to save it, they get an error message that they do not have
>> the permission to "msystables" that they need.
>>
>> 1. I did not change the owner of MSysAccessObjects to myself so how
>> is this set to me as the owner?
>
> By the security wizard.
>
>> 2. Why is MSysAccessXML's owner Admin when Admin should have no
>> rights at all, and that is how I thought I had set it up.
>
> By the security wizard.
>
>> 3. What user name should be the owner of these objects?
>
> Don't change them. They are as they should be. You should not
> change the permission of any system object.
>
>> 5. How can I give my users permission to save custom queries and
>> reports?
>
> I assume that you are using Access 2003 and that you used the security
> wizard to implement security. If that's not correct then ignore the
> following.
>
>>
>> I'm using a form that lists the following code in a combo box to
>> allow users to see the queries that they have saved provided they
>> save them correctly.
>
> It will also show them queries saved by other users.
>
>> These work fine for me (I am a member of the Admins group), but for
>> users with limited permissions, they can create and run a query, but
>> they cannot save the query.
>>
>> 6. Even as a member of the Admins group, I do not have access to
>> view or modify the tables where Engine is the Owner. Can this be
>> changed so that I can accomplish what I need to accomplish?
>
> No, you can't change that. Nor should you view or modify those
> tables.
>
>>
>> 7. Users that don't have administrative permissions can see the list
>> created by the SQL statement above, and can select a query from the
>> combo box. But when they click on the button to run the query which
>> uses the code below to run the query
>> DoCmd.OpenQuery Me.cmbQuery.Value, acViewNormal, acReadOnly
>> they get the message that they do not have the necessary permission
>> to run the query 'queryname' even though the query has RWOP and
>> Owner (me) has full access.
>
> Yes but do the users have permission on the RWOP query (not the
> tables, but the query)
>
> As for the MSysTables error, that will happen if you create a new
> group (not one that the wizard offers) and want this group to be able
> to save queries (only in Access 2003 though). The workarounds are:
>
> Don't use the security wizard if you want to create extra groups.
> Secure it manually in this case.
> Or
> Make users in your custom group also be a member of any of the Wizard
> supplied groups (read-only will do).

Another possibility for that error. If you have code that modifies the SQL
property of a saved query, you need to give users permission to modify the
query, but that doesn't sound as though it's the problem in your case.


--
Joan Wild
Microsoft Access MVP


.