[AccessD] Closing mdb file via vba

You might be able to use GetObject, which will grab an existing session.
But if more then one instance is open, not sure how to grab that.  

Two methods I would suggest would be to get the hwnd, and send the
'close window' message to it.  Or create a process inside the .mdb you
want to be able to close remotely, that listens for something, either a
flag in a table, or a TCP/IP message.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Annie
Courchesne, CMA
Sent: Sunday, February 24, 2008 12:54 PM
To: Accessd
Subject: [AccessD] Closing mdb file via vba

Hi all,

 

Is there a way to close a mdb file (not the one currently used) via vba
code?

 

Thanks!

 

 

Annie Courchesne, CMA

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.