close mdb from calling mdb

[iccsi]

Is it possible to close called mdb from calling mdb?
I have one launch center calling another mdb and would like to close
called mdb from calling mdb when user closes the calling mdb.


Your informaiton is great appreciated,

 

[Daniel Pineault]

It depends on how you call it in the first place. If you use FollowHyperlink
then things get very complicated, but if you used something like:

dim accapp as access.application
set accapp = new access.application
accapp.opencurrentdatabase("c:\YourDbName.mdb")
....

Then you could do accapp.Quit

How do you launch it in the first place?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[iccsi]

It depends on how you call it in the first place.  If you use FollowHyperlink
then things get very complicated, but if you used something like:

dim accapp as access.application
set accapp = new access.application
accapp.opencurrentdatabase("c:\YourDbName.mdb")
...

Then you could do accapp.Quit

How do you launch it in the first place?
--
Hope this helps,

Daniel Pineaulthttp://www.cardaconsultants.com/
For Access Tips and Examples:http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.






- Show quoted text -

I use Shell(MS Access mydb.mdb)


Thanks again,

 

[Daniel Pineault]

Personally, I'd convert your code per my original e-mail as it would provide
you with the ability to manipulate to opened access instance.

Otherwise, you have to identify the application instance and close it down.
You'd have to start using code such as:

http://www.mvps.org/access/api/api0007.htm
http://www.mvps.org/access/api/api0013.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[iccsi]

Personally, I'd convert your code per my original e-mail as it would provide
you with the ability to manipulate to opened access instance.

Otherwise, you have to identify the application instance and close it down.  
You'd have to start using code such as:

http://www.mvps.org/access/api/api0007.htmhttp://www.mvps.org/access/api/api0013.htm
--
Hope this helps,

Daniel Pineaulthttp://www.cardaconsultants.com/
For Access Tips and Examples:http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.








- Show quoted text -

Is it possible to identify mdb opened by Windows Handle ID?
If yes, are there any API to do so?

Your information is great appreciated,