DDE Link to ACcess 2003

[Bill Braun]

I am trying to establish a DDE link from a simulation program to
Access 2003. Is there standard notation for describing Service,
Topic, and Item?

I want to connect to a table named PSimTest in the database
Sim.mdb and read multiple rows of data in the field Var1. Var1
is of DataType Number.

Thank you,

Bill

 

[Sylvain Lafontaine]

You can't do this using a DDE link (well, you could but this would require a
lot of knowledge about the internal working of Access and in any case, is
probably a very bad idea to do). Instead, you must (should) use ADO (or DAO
but in your case, ADO is probably better) to connect to the database and
retrieve data.

Search Google for ADO (Connect, Command and Recordset objects) and take a
look at the previous posts in this newsgroup and in m.p.a.modulesdaovba.ado
and m.p.a.odbclientsvr for some examples.

DDE is a very old technology that is no longer in real use.

 

[Sylvain Lafontaine]

Take a look also as the newsgroup m.p.data.ado (as well as .odbc and
..oledb). For connection strings, see:

http://www.connectionstrings.com/
http://www.carlprothman.net/Default.aspx?tabid=81
http://www.asp101.com/articles/john/connstring/default.asp

 

[Bill Braun]

Thank you, Sylvain. I don't disagree about your point that DDE
is old technology; for better or worse, it is the technology
that the simulation engine uses, so I have to/want to find a way
to use it.

I'll look into the ADO or DAO technology of which you speak.

Thanks again,

Bill

 

[Sylvain Lafontaine]

http://msdn2.microsoft.com/en-us/library/aa172266(office.11).aspx

Don't forget to activate the DDE calls in the options in Access.

 

[John Nurick]

Hi Bill,

Here's a good place to start:
http://msdn2.microsoft.com/en-us/library/aa201988(office.10).aspx

For more, try googling
"microsoft access" "dde server" site:microsoft.com