Security problem in Access 2000 - Admins user can't change query design

[Richard Sherratt]

I create a new user and make them a member of Admins. I then log on as
that user and try to modify an existing query. I'm told that I don't
have the necessary permissions. The Admins group has full permissions
on the query.

The new user can create new queries and modify them, but the database
owner cannot modify these queries, even though the database owner
explicitly had Administer permission on them.

A possible related issue is that the owner of query objects cannot
change owner to someone else.

The new user can change the design of forms and reports.

Any ideas.

--
Regards.
Richard.

[David Schofield]

On Mon, 29 Nov 2004 06:56:36 GMT, Richard Sherratt
<ri**************@NOTHINGHEREbrunsley.com.au> wrote:

I create a new user and make them a member of Admins. I then log on as
that user and try to modify an existing query. I'm told that I don't
have the necessary permissions. The Admins group has full permissions
on the query.

The new user can create new queries and modify them, but the database
owner cannot modify these queries, even though the database owner
explicitly had Administer permission on them.

A possible related issue is that the owner of query objects cannot
change owner to someone else.

The new user can change the design of forms and reports.

Any ideas.

--
Regards.
Richard.

Hi
Is this an owner-access query? I seem to remember that these can only
be modified by the owner, though I could be wrong.
David

[Richard Sherratt]

On 30 Nov 2004 14:54:17 -0600, d.***************@blueyonder.co.uk
(David Schofield) wrote:

<snip>

Is this an owner-access query? I seem to remember that these can only
be modified by the owner, though I could be wrong.

Ding!

Thanks :-)

--
Regards.
Richard.