@Bridge: "Hi, all,
I've got a secured Access 2003 db w/3 users set up as Admins.  The Admins 
also have Modify Design permission on all tables/queries.  
For some reason, my database won't allow anyone in the Admins group other 
than the object owner to modify the query design.  Any idea what I'm doing 
wrong?
We're running Windows XP.  These 3 users have read/write access to the 
shared folder where the Db resides.
As always, thanks in advance for your help,
Bridge"
    @jwild: "What message do you get?  Also, they would need to open the mdb =
exclusively to make design changes. =20
=20
Joan Wild
Microsoft Access MVP
"Bridge" <email_address> wrote in message =
news:<email_address>
<quote>
Admins=20
other=20
doing=20"
    @Bridge: ""You do not have the necessary permissions to use the "Recon Query" object.  
Have your system administrator or the person who created the object establish 
the appropriate permissions for you."
<quote>"
    @jwild: "If you are certain that the users have modify design permission to the =
Recon Query, check to see if it is set to RWOP - you could change the =
owner to the Admins Group rather than a user.
=20
Joan Wild
Microsoft Access MVP
"Bridge" <email_address> wrote in message =
news:<email_address>
<quote>
object. =20
establish=20
exclusively to make design changes. =20
news:<email_address>
Admins=20
other=20
I'm doing=20
the=20"
    @Bridge: "Hi, Joan,
I tried to change the owner to "Admins" but I got a message that said, "You 
don't have permission to change the owner of this object."  I've 
double-checked my permissions, and I definately have that.  
What should I try next?
Thanks,
Bridge
<quote>"
    @jwild: "Is this a RWOP query?  You have to login as the user that currently owns =
the query.  You'll then be able to change the owner.
=20
Joan Wild
Microsoft Access MVP
"Bridge" <email_address> wrote in message =
news:<email_address>
<quote>
"You=20
the Recon Query, check to see if it is set to RWOP - you could change =
the owner to the Admins Group rather than a user.
news:<email_address>
object. =20
establish=20
exclusively to make design changes. =20
news:<email_address>
The Admins=20
group other=20
I'm doing=20
to the=20"
    @Bridge: "The error occurs if I try to change the design of a form, report, or query.  
And I am the owner of the object, so it should allow me to change the owner.  
Unfortunately, it doesn't allow me to do so.
Any ideas?
Bridge
<quote>"
    @jwild: "I haven't heard of this before.  If you are logging in as the owner then =
you should be able to change the ownership and/or permissions on the =
object.=20
The only thing I can think of is that the object is owned by someone =
else.
=20
Joan Wild
Microsoft Access MVP
"Bridge" <email_address> wrote in message =
news:<email_address>
<quote>
query. =20
owner. =20
owns the query.  You'll then be able to change the owner.
news:<email_address>
said, "You=20
the Recon Query, check to see if it is set to RWOP - you could change =
the owner to the Admins Group rather than a user.
news:<email_address>
Query" object. =20
object establish=20
exclusively to make design changes. =20
news:<email_address>
 The Admins=20
group other=20
what I'm doing=20
access to the=20"
    @KevinSlovickNetworkEngineer: "Try applying this patch:
<url>
Office SP3 broke some MS Access 2003 security and required users to have 
Full permissions to do common tasks.  Modify permissions would not let them 
do it.
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 8, "forum_name": "microsoft.public.access.security.20140605.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}