Using DDE in Visual Basic

[chicagirl55]

I'm using DDE with VB6 to write to a database in Access. Every once in a while I get an error and the program stops writing to the database because the DDE service has stopped on the computer. Does anybody know what I need to do to make the program run continuously without me having to physically restart the service on the computer again?

 

[TammyKing]

Hi,

I would really recommend not using DDE, instantiate the Access olb and you will have much better control over the app. OLE has pretty much replaced DDE. You can use the object browser to find the Access object.

If you have trouble let me know, I will post some sample code.

Good Luck, Tammy

 

[chicagirl55]

I am using some older hardware that the program is controlling so I've been told that I can't swithch over from DDE. I looked into replacing that hardware but it's several thousand dollars that we can't afford in the lab at the moment. If you have any tips for using DDE still I would greatly appreciate it, but thanks for your input!