DDE Link to ACcess 2003

  • Thread starter Thread starter Bill Braun
  • Start date Start date
B

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
 
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.
 
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
 
Back
Top