Home All Groups Group Topic Archive Search About

Open an Access Database from Another

Author
5 Dec 2006 2:34 AM
Len
I would like to open one Access database from a form on another.  Is the
Shell function the best way to do this. - Thanks

Author
5 Dec 2006 2:55 AM
Joan Wild
Yes it is.  That or TSI SOON.  See
http://www.mvps.org/access/modules/mdl0005.htm

--
Joan Wild
Microsoft Access MVP

Len wrote:
Show quoteHide quote
> I would like to open one Access database from a form on another.  Is
> the Shell function the best way to do this. - Thanks
Author
5 Dec 2006 3:06 AM
Len
If I use the Shell function - is there a way to send the user id and password
that the original database was opened with along to the other Access database?

Show quoteHide quote
"Joan Wild" wrote:

> Yes it is.  That or TSI SOON.  See
http://www.mvps.org/access/modules/mdl0005.htm
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Len wrote:
> > I would like to open one Access database from a form on another.  Is
> > the Shell function the best way to do this. - Thanks
>
>
>
Author
5 Dec 2006 2:44 PM
Joan Wild
Not without asking for their password again.  See for an example of opening
a secure mdb from an unsecure one.
http://www.access.qbuilt.com/html/custom_login.html


--
Joan Wild
Microsoft Access MVP

Len wrote:
Show quoteHide quote
> If I use the Shell function - is there a way to send the user id and
> password that the original database was opened with along to the
> other Access database?
>
> "Joan Wild" wrote:
>
>> Yes it is.  That or TSI SOON.  See
>>  http://www.mvps.org/access/modules/mdl0005.htm
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Len wrote:
>>> I would like to open one Access database from a form on another.  Is
>>> the Shell function the best way to do this. - Thanks
Author
5 Dec 2006 4:42 PM
Len
Thank you very much. I will try this method.

Show quoteHide quote
"Joan Wild" wrote:

> Not without asking for their password again.  See for an example of opening
> a secure mdb from an unsecure one.
http://www.access.qbuilt.com/html/custom_login.html
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Len wrote:
> > If I use the Shell function - is there a way to send the user id and
> > password that the original database was opened with along to the
> > other Access database?
> >
> > "Joan Wild" wrote:
> >
> >> Yes it is.  That or TSI SOON.  See
> >>  http://www.mvps.org/access/modules/mdl0005.htm
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> Len wrote:
> >>> I would like to open one Access database from a form on another.  Is
> >>> the Shell function the best way to do this. - Thanks
>
>
>