I Can Start The DDE Service, But How Do I Stop It??

[chicagirl55]

I am using VB 6 to write to an Access datadase. I've been having problems starting and stopping the DDE services in the code recently. I figured out how to start the DDE service on the computer but now I need to figure out how to stop it. Here's what I have now:

Select Case SourceErrorCode 
    Case 297 'No DDE Connection 
      Call cmdEstablishDDE_Click 
      errorhandler = True 
    Case 286 'Net DDE Service Not Running 
      Response = Shell("c:\Winnt\System32\NetDDE.exe", vbMinimizedNoFocus) 
      If Response <> 0 Then errorhandler = True 
    Case 282 'Net DDE Service Not Running 

      Response = Shell(&quot;c:\Winnt\System32\NetDDE.exe&quot;, vbMinimizedNoFocus) 
      If Response <> 0 Then errorhandler = True

Any ideas on how to stop the DDE service would be greatly appreciated! Thanks.


Don't we all feel like this every once in a while?