"croy" wrote:

> On Tue, 23 Dec 2008 20:30:17 -0500, "Joan Wild"
> <jwild@nospamtyenet.com> wrote:
>
> >Access doesn't see you as being in the Admins Group - so you appear to be
> >using the wrong mdw at the time you attempt this (at least as far as Access
> >is concerned)
>
> But, the security add-in's message states that ownership
> can't be changed for a query that is set to run with owner's
> permissions.  That lines up with what I'm experiencing. When
> I flip the RunWith bit from "owner's" to "user's", I can
> then do anything I want in the way of modify, save, change
> ownership, etc.  I can also modify and save any other object
> (tables, forms, reports, etc.).
>
> A couple of questions here, as I ponder some of the things I
> thought I knew...
>
> Am I wrong to think that if I were using the wrong mdw, that
> I wouldn't be able to modify and save the querys at all,
> even *if* I change the RunWith bit?
>
> Also, am I wrong in thinking that if I import a query from
> another mdb, that the ownership (in the receiving mdb)
> should be mine, thereby giving me carte blanche permissions
> on it?
>
> Over the holidays, I'm going to pour over the FAQ again, and
> hopefully find something I've missed, and reinforce where my
> understanding is correct (although *that* may be a very
> short list!).
>
> Happy holidays, and belated winter solstice!
>
> --
> croy
>
> "A baby in motion is a body at rest."
>
>  - author unknown
>