adccommunitymod (AutomationDirect) asked a question.

KEPDirect and Access

Created Date: August 12,2006

Created By: robertkeenan

**** This post has been imported from our legacy forum. Information in this post may be outdated and links contained in the post may no longer work.****

I am using a DL06 to send data back to an Access database using KEPDirect as the DDE server. My problem is that I know little about PC programming and so to make the project work I have Access polling every 3s to see if the value of C100 has changed and therefore new data is available. What this means is that every 3s the PC comes to a halt. I could increase the time as it only needs to read data every couple of minutes but this means that at the other end if the PLC misses a slot then it will have to wait a coupl of minutes before it can start the next test. I can see that Access can have events triggered by a button which start reading data but is there an event which can be triggered by a change in a DDE value which would have the same effect as having a button on the screen If I can get this to work then I will have have to learn how to do it using an SQL server. Would this be possible.


  • adccommunitymod (AutomationDirect)

    Created Date: August 12,2006

    Created by: robertkeenan

    I am using a DL06 to send data back to an Access database using KEPDirect as the DDE server. My problem is that I know little about PC programming and so to make the project work I have Access polling every 3s to see if the value of C100 has changed and therefore new data is available. What this means is that every 3s the PC comes to a halt. I could increase the time as it only needs to read data every couple of minutes but this means that at the other end if the PLC misses a slot then it will have to wait a coupl of minutes before it can start the next test. I can see that Access can have events triggered by a button which start reading data but is there an event which can be triggered by a change in a DDE value which would have the same effect as having a button on the screen If I can get this to work then I will have have to learn how to do it using an SQL server. Would this be possible.

    Expand Post