Just wanted everyone to know this works great (although it does not
maximize as it should). I appreciate the help.
>> If you want the processes in your first database to stop until the
s> econd database is closed then go to
h> ttp://www.mvps.org/access/api/api0004.htm and download the API: Start
a> n app with ShellExecute code written by Terry Kreft.
> If you want the processes in your first database to continue when the
s> econd database is opened then go to
h> ttp://www.mvps.org/access/api/api0018.htm and download the code API:
S> hell and Wait written by Dev Ashish.
J> ohn Ruff - The Eternal Optimist :-)
A> lways Looking for a Contract Opportunity
9> 306 Farwest Dr SW
L> akewood, WA 98498
-> ----Original Message-----
F> rom: Amy Wyatt [mailto:amyw@c...]
S> ent: Thursday, May 30, 2002 1:48 PM
T> o: Access
S> ubject: [access] Opening 2nd Access DB from first Access DB
> Just wondering if anyone has been able to accomplish the following:
> When my main database is open I would like to allow a user to click on a
> button that would open a second database (a maintenance database) while
s> till leaving the main DB open.
> I can accomplish this in Access 97 no problem but when attempting it in
A> ccess 2000 the database opens flashes up and then immediately closes
i> t hits the End Function statement, even thought there is no Quit, Close
> Database or Close Application statement anywhere.
> I am not getting an error but the application will just not stay open.
a> nyone has any ideas on how to make this work, please let me know.
> Thanks in advance,
> Amy Wyatt
C> hange your mail options at
t> o unsubscribe send a blank email to