DDEInitiate Function

[SteveJR]

All,

I am trying to use DDE within my database and I am having a little problem with the Initiate call.

Can anyone tell me if there is a way to find out what you should pass as the program name in the call? i.e. if using excel then you would use ddeinitiate("Excel", "System&quot. But what should you do if you don't know what the program you are using should be referenced as?

Any help would be much appreciated.

Thanks,

Steve

 

[Francescina]

DDE is a technique that worked quite well with Access 2.0, but with newer versions you should exclusively work with OLE. In instatiating an Excel object (you need a reference to the Excel object library!) you can use all methods of the Excel object model.

 

[Stickarm]

What is the application you are using? Check the help files of the program you are using and if it supports DDE, it should give you some hints.

 

[SteveJR]

I am using an application called OutSideView. It is an emulation product. The help files are not very helpful and only tell me the syntax of the statement!

I will try to get OLE working but I think I will have the same problem with not knowing what name to use as the Object.

Thanks.

Steve

 

[Stickarm]

What is the Executable called? Outsideview.exe? If so, have you tried DDEINITIATE ("Outsideview","SessionName&quot.

 

[SteveJR]

Stickarm,

The executable is called Outside. I tried using this but it still didn't work. I decided to look on the makers websire and found some info there but it was for the newer version of the software. I have emailed the makers to find out what I need to use. When I get an answer I will post a message.

Thanks for your suggestions,

Steve

 

[SteveJR]

All,

Thanks for replying to this thread. I have found out from the makers that the version of software I am using can only be used as a client with DDE and not a server. Ah well, at least I tried!

Thanks again,

Steve