You can use the DDETerminateAll statement to close all open dynamic data exchange (DDE) channels.
For example, suppose you have opened two DDE channels between Microsoft Excel and Microsoft Access, one to retrieve system information about Microsoft Excel and one to transfer data. You can use the DDETerminateAll statement to close both channels simultaneously.
DDETerminateAll
Using the DDETerminateAll statement is equivalent to executing a DDETerminate statement for each open channel number. Like the DDETerminate statement, the DDETerminateAll statement has no effect on active DDE link expressions in fields on forms or reports.
If there are no DDE channels open, the DDETerminateAll statement runs without causing an error.
Tip If you interrupt a procedure that performs DDE, you may inadvertently leave channels open. To avoid exhausting system resources, use the DDETerminateAll statement in your code or from the Immediate tab of the Debug window while debugging code that performs DDE.
Tip If you need to manipulate another application’s objects from Microsoft Access, you may want to consider using OLE Automation.
DDE Function, DDEExecute Statement, DDEInitiate Function, DDEPoke Statement, DDERequest Function, DDESend Function, DDETerminate Statement.
See the DDE function example.