|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Permissions and Object OwnersHi, 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 What message do you get? Also, they would need to open the mdb exclusively to make design changes.
-- Joan Wild Microsoft Access MVP Show quote "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:B86CEE0E-B11A-4415-9460-BD982429EA3F@microsoft.com... > 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 "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." Show quote "Joan Wild" wrote: > What message do you get? Also, they would need to open the mdb exclusively to make design changes. > > -- > Joan Wild > Microsoft Access MVP > "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:B86CEE0E-B11A-4415-9460-BD982429EA3F@microsoft.com... > > 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 > 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.
-- Joan Wild Microsoft Access MVP Show quote "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:3672B4E3-3D32-4141-A952-2A74132D6123@microsoft.com... > "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." > > "Joan Wild" wrote: > >> What message do you get? Also, they would need to open the mdb exclusively to make design changes. >> >> -- >> Joan Wild >> Microsoft Access MVP >> "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:B86CEE0E-B11A-4415-9460-BD982429EA3F@microsoft.com... >> > 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 >> 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 Show quote "Joan Wild" wrote: > 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. > > -- > Joan Wild > Microsoft Access MVP > "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:3672B4E3-3D32-4141-A952-2A74132D6123@microsoft.com... > > "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." > > > > "Joan Wild" wrote: > > > >> What message do you get? Also, they would need to open the mdb exclusively to make design changes. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:B86CEE0E-B11A-4415-9460-BD982429EA3F@microsoft.com... > >> > 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 > >> > 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.
-- Joan Wild Microsoft Access MVP Show quote "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:043639D0-0196-4D57-93F9-E2CAA0542D74@microsoft.com... > 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 > > "Joan Wild" wrote: > >> 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. >> >> -- >> Joan Wild >> Microsoft Access MVP >> "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:3672B4E3-3D32-4141-A952-2A74132D6123@microsoft.com... >> > "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." >> > >> > "Joan Wild" wrote: >> > >> >> What message do you get? Also, they would need to open the mdb exclusively to make design changes. >> >> >> >> -- >> >> Joan Wild >> >> Microsoft Access MVP >> >> "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:B86CEE0E-B11A-4415-9460-BD982429EA3F@microsoft.com... >> >> > 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 >> >> >> 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 Show quote "Joan Wild" wrote: > 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. > > -- > Joan Wild > Microsoft Access MVP > "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:043639D0-0196-4D57-93F9-E2CAA0542D74@microsoft.com... > > 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 > > > > "Joan Wild" wrote: > > > >> 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. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:3672B4E3-3D32-4141-A952-2A74132D6123@microsoft.com... > >> > "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." > >> > > >> > "Joan Wild" wrote: > >> > > >> >> What message do you get? Also, they would need to open the mdb exclusively to make design changes. > >> >> > >> >> -- > >> >> Joan Wild > >> >> Microsoft Access MVP > >> >> "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:B86CEE0E-B11A-4415-9460-BD982429EA3F@microsoft.com... > >> >> > 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 > >> >> > >> > 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.
The only thing I can think of is that the object is owned by someone else. -- Joan Wild Microsoft Access MVP Show quote "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:FBB806FD-074A-49D2-8772-00AF9A0B9CDC@microsoft.com... > 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 > > "Joan Wild" wrote: > >> 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. >> >> -- >> Joan Wild >> Microsoft Access MVP >> "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:043639D0-0196-4D57-93F9-E2CAA0542D74@microsoft.com... >> > 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 >> > >> > "Joan Wild" wrote: >> > >> >> 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. >> >> >> >> -- >> >> Joan Wild >> >> Microsoft Access MVP >> >> "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:3672B4E3-3D32-4141-A952-2A74132D6123@microsoft.com... >> >> > "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." >> >> > >> >> > "Joan Wild" wrote: >> >> > >> >> >> What message do you get? Also, they would need to open the mdb exclusively to make design changes. >> >> >> >> >> >> -- >> >> >> Joan Wild >> >> >> Microsoft Access MVP >> >> >> "Bridge" <Bri***@discussions.microsoft.com> wrote in message news:B86CEE0E-B11A-4415-9460-BD982429EA3F@microsoft.com... >> >> >> > 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 >> >> >> >> >> >>  |
|||||||||||||||||||||||
Other interesting topics