"Joan Wild" wrote:
> > Hello,
> > two short questions:
> > a) if I choose file>new> new blank database from a secured database, will
> > the new database use the same .mdw file that is used from the secured
> > database?
>
> Yes.  The mdw remains for the entire session of Access.
>
> > I don't think so, because if then I use the new database while joining the
> > default .mdw (system.mdw), the owner of objects in the new database is
> > *unknown*, but 90% of the times i'm wrong with these security things.
>
> That makes perfect sense.  The system.mdw does not contain the username that
> you were logged in as under the secure mdw session.  Therefore it lists
> 'unknown' as the owner, since the owner is unknown to the system.mdw file.
>
> >
> > b) In any case, what is the best way to go to secure a new database with
> > an
> > existing .mdw file?
>
> As per a)
> --
> Joan Wild
> 520630

news:CEBB3C3E-AC01-4ED0-BAE5-A7E5A1F3F3D0@microsoft.com...

> Hi Joan,
> sorry to bother...
> you have already answered to a question I posted (see below).
> I rated it as *solved*, which I think it is since you are the *boss* on
> these topics.
> But another, related, question pops up on my mind:
>
> If the new database will use the same .mdw file that is used for the secured
> database, since i'm currently joined throguh the system.mdw file (1) why it
> doesn't ask me for the user ID and password?
>
> I can open the db without any problem. It seems it is not secured at all.
> "Admin" in file (1) has no permission to do anything but while logging as
> Admin through the system.mdw I built and saved a form.