p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

access thread: RE: Opening 2nd Access DB from first Access DB

Message #1 by "Amy Wyatt" <amyw@c...> on Mon, 3 Jun 2002 19:59:14
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

>  xxx.xxx.xxxx
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
w> hen 
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.
I> f 
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 

  Return to Index