Application.DDETerminateAll (Access)

You can use the DDETerminateAll statement to close all open dynamic data exchange (DDE) channels.

For example, suppose you've opened two DDE channels between Microsoft Excel and Microsoft Access, one to retrieve system information about Excel and one to transfer data. You can use the DDETerminateAll statement to close both channels simultaneously. 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 a run-time error.

DDETerminateAll