Excel DDE Server -> Access DDE Client

[WonLee]

Hi everyone,

I have an application running. We will call it applicationX. ApplicationX functions as, among other things, a DDE server. The application, on install, modifies Excel, making it a valid DDE client.

How do I make Access a DDE client that can create a hot link with
applicationX?

If this is not possible, or difficult, can I make Access a DDE client of Excel, while Excel is functioning as a DDE client of ApplicationX?

*I'm not really an Access developer, but I am willing to read. I'm asking that someone could point me in the right direction and tell me what documentation I need to read.

Thanks
Won Lee

 

[RichMorrison]

You might find some information in the various "Access Developer's Handbook" versions. The publisher is Sybex and the authors are Litwin, Getz, and others.

I have the Access 97 version and it does have a section about Access as both client and server.

However, DDE is dead technology. Access 97 and up use "Office Automation" which is based on OLE (the successor to DDE)

Good luck,
RichM

 

[WonLee]

Rich,

Thanks for the info.
I've actually learned that applicationX might support COM support.

I will invesigate your book recommendation if applicationX does not support COM.