|
 |
access thread: Opening 2nd Access DB from first Access DB
Message #1 by "Amy Wyatt" <amyw@c...> on Thu, 30 May 2002 13:48:00
|
|
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
still leaving the main DB open.
I can accomplish this in Access 97 no problem but when attempting it in
Access 2000 the database opens flashes up and then immediately closes when
it 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. If
anyone has any ideas on how to make this work, please let me know.
Thanks in advance,
Amy Wyatt
Message #2 by "John Ruff" <papparuff@c...> on Thu, 30 May 2002 07:12:34 -0700
|
|
If you want the processes in your first database to stop until the
second database is closed then go to
http://www.mvps.org/access/api/api0004.htm and download the API: Start
an app with ShellExecute code written by Terry Kreft.
If you want the processes in your first database to continue when the
second database is opened then go to
http://www.mvps.org/access/api/api0018.htm and download the code API:
Shell and Wait written by Dev Ashish.
John Ruff - The Eternal Optimist :-)
Always Looking for a Contract Opportunity
xxx.xxx.xxxx
9306 Farwest Dr SW
Lakewood, WA 98498
-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Thursday, May 30, 2002 1:48 PM
To: Access
Subject: [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
still leaving the main DB open.
I can accomplish this in Access 97 no problem but when attempting it in
Access 2000 the database opens flashes up and then immediately closes
when
it 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.
If
anyone has any ideas on how to make this work, please let me know.
Thanks in advance,
Amy Wyatt
Message #3 by "Amy Wyatt" <amyw@c...> on Thu, 30 May 2002 15:29:38
|
|
Thanks John, I will have a look and give it a try.
Amy
> If you want the processes in your first database to stop until the
second database is closed then go to
http://www.mvps.org/access/api/api0004.htm and download the API: Start
an app with ShellExecute code written by Terry Kreft.
If you want the processes in your first database to continue when the
second database is opened then go to
http://www.mvps.org/access/api/api0018.htm and download the code API:
Shell and Wait written by Dev Ashish.
John Ruff - The Eternal Optimist :-)
Always Looking for a Contract Opportunity
xxx.xxx.xxxx
9306 Farwest Dr SW
Lakewood, WA 98498
-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Thursday, May 30, 2002 1:48 PM
To: Access
Subject: [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
still leaving the main DB open.
I can accomplish this in Access 97 no problem but when attempting it in
Access 2000 the database opens flashes up and then immediately closes
when
it 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.
If
anyone has any ideas on how to make this work, please let me know.
Thanks in advance,
Amy Wyatt
|
|
|
View Cart
