Re: Object permissions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi, Joan.

You can, and I have, made a group the owner of an object.

Doh! Thanks for the correction. I could have sworn I've done the same thing as
Scott and received the same error message because I accidentally grabbed the
group name, not the user name when I assigned the new owner. I can see that
there's no such problem when I try it now.

Thanks.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.


"Joan Wild" <jwild@xxxxxxxxxxxxxxxx> wrote in message
news:upJGqprIHHA.5104@xxxxxxxxxxxxxxxxxxxxxxx
'69 Camaro wrote:
So I tried to change the object's owner to the group "Admins"
. . .
Am I missing something here?

Yes. You may assign one -- and only one -- user as the new owner of
the object. A group is not a user. A group contains zero to many
users as members, so a group is related conceptually to users, but a
group can't substitute for a user as the "owner."

You can, and I have, made a group the owner of an object. Doesn't matter in
Scott's case, but I thought I'd point out that this can be done.

--
Joan Wild
Microsoft Access MVP



.

Relevant Pages

  • Re: Saving a form discards the digital certificate
    ... they get an error message ... We much prefer lengthy well written postings to short postings without ... significant amount of time researching some alternatives and actually ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: INSERT INTO Query Question
    ... query I get the following response: "Microsoft Access can't append all the ... records in the append query. ... the following error message as I attempt to run an append query: ... FROM [prospect list]; ...
    (microsoft.public.access.queries)
  • Re: A real learners question!
    ... I have renamed everything without spaces but I still get the error message ... I currently get an error message saying "Microsoft Access can't find macro ... event of the details form. ...
    (microsoft.public.access.forms)
  • Re: Access 2003 Error: 3218 Could not update; currently locked
    ... stuart wrote: ... She said that she did not get any type of error message ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • aspx Error Message
    ... following error message is issued: ... The Access database is not opened by another so I don't know why it is being ... Microsoft Access can't open the database because it is missing, ...
    (microsoft.public.dotnet.framework.aspnet)