ACC: How to Use the Quit Macro ActionLast reviewed: August 29, 1997Article ID: Q100149 |
The information in this article applies to:
SUMMARYAdvanced: Requires expert coding, interoperability, and multiuser skills. This article demonstrates two methods to close Microsoft Access from a different application. The first method uses the Quit macro action to quit Microsoft Access over a dynamic data exchange (DDE) channel. The second method uses Automation and the Quit method.
MORE INFORMATION
Dynamic Data Exchange methodThe syntax for the Quit action is:
QuitThere are no parameters for the Quit action. The following example shows a Microsoft Excel version 4.0 macro to demonstrate the Quit macro action. The macro is valid for Microsoft Excel versions 4.0, 5.0, and 7.0 and Microsoft Excel 97. NOTE: This macro will not work with Microsoft Access version 1.0.
Automation MethodThis method is exclusive for Microsoft Access 7.0 and Microsoft Access 97. Earlier versions of Microsoft Access are not OLE Servers, and therefore you can't manipulate them using Automation.
REFERENCESFor more information about the Quit method, search the Help Index for "Quit method," or ask the Microsoft Access 97 Office Assistant. For more information about using macro actions in DDE, please see the following article here in the Microsoft Knowledge Base:
ARTICLE-ID: Q97776 TITLE: ACC: Running a MS Access Macro from Visual Basic Using DDE |
Additional query words: ole/dde server
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |