Arthur,

Is this a plugin for the TCP/IP version? Can it be used for TCP/IP or RS232 only? Right now i have flawless connection with your TCP/IP datalogger. It even re-connects when power was down.

I am very interested to try this, i have little to no experience with ActiveX though. I hope there are some examples to use this with Access.

I would love to have this ActiveX do some triggering in my front end database. Besides that i would like to keep ODBC connection too as backup when front end is not running as redundancy.

I will look up the documentation you have on this. I will need more help.

Thanks,
Otto

Arthur,

The example u suggested is strictly for visual basic. I am running MsAccess with VB for access in back ground.

I've been looking up lot's of information to Use DDE server. What i need a way to send a Field Postamble DDE command. This needs to be send after the last data that was recieved from IP address.

When i make a macro in VB, the macro will automatically become a valid DDE command as long as the database is open. This is something i've been looking for a long time.

This seems to be the only way to create a trigger between TCP/IP datalogger and my MsAccess database to refresh data in a form.

Can your DDE server software send postamble DDE commands towards msaccess? please help.

Thank You,
Otto

I need help setting up a DDE link using ms access. I am familiar using VBA. I've need to switch to DDE links because ODBC links (which works really great) do not update a value on a form automatically but in the background straight into the mdb. I need the data to appear (refresh) on a screen when new data arrives.

Please help, i need a good example. I probably can figure out loose ends myself.

Thanks
Otto

Thanks,

I've looked in the tutorial but could not find a good example on how to do this. How do i refer to a DDE link in MSaccess?

Otto

Athur,
is there a way to to remotely pause/start the TCP/IP datalogger software? Via DDE or ODBC, activeX or any other way? I would like to create a button on my msaccess application to reset this. That would solve the keep alive issue. I already tested the keep alive with my ACT converters. It's not working.

Thanks,
Otto

Luis,

I just wanted to let you know that i have succesfully tested 4 ACT1000's connected to TCP/IP data logger. Only glitch is that when power fails at the converters the connection needs to be reset in the TCP/IP software. Just hit pause and play button is enough. This i will have to find a solution for still. But the connection otherwise is rock solid. The ports are always open and ready to recieve data.

my data goes to a access database. now i will need to find out a way to refresh the form upon recieving new data. this has proven some difficulties sofar.

Anyway, i promissed you an update, there it is.
Good luck,
Otto

Hi,

I know my question is going to be a little off topic. I need to refresh a MSaccess database subform after new data was transferred with the TCP/IP data logger software with the ODBC plugin. Right now i am using a timer that refreshes the whole form. Not an ideal situation. What i need is a refresh trigger (VBA or thru ODBC or something) that is triggered as soon an new data enters the data base. Maybe i need to find other way of transferring the data?  DDE? The nice thing about ODBC is that i can even close the application but still recieve data in the database. Now only if i could find a way to refresh when new data arrives.

who can help me with this one? Thanks in adance.

Otto

Luis,

Back to the problem on your 1st message. Have you thought about keeping the power on to the serial converter? And also try to find a power source for your server that does not get switched off.

By the way. The converter that i am using, the ACT1000 stays always open. I have been testing for almost a week including a weekend. The TCP port stays open. Thursday i get three more ACT's and will use them with the same TCP/IP data logger software hoping the other three IP numbers will behave the same.

good luck,
Otto

Arthur,

Is there a way to send a bit to a database field via ODBC to check if the TCP connection is still up between serial converter and TCP/IP datalogger software? Maybe even better if this is live signal available with DDE via network. I would like to be able the check connection status via my VBA for Access GUI. I have four different IP's that i'm listening to. I would like to show status with red or green dot for quick visual purpose.

Thanks,
Otto

No problem, thanks for your reply.
Otto

Athur,
Please help getting the ODBC settings under services. I cannot find the ODBC panel from the services panel.

For some reason the TCP/IP software stops working after some time. I set the log files, i'm trying to find out why it stops. Maybe because it looses connection with three out of four serial converters. I'm still testing your TCP software because i would not like to use three pieces of software to accomplish the same goal.

The software hasn't stopped whenever i run it as a service, that's why i want to go that route.

Thanks for your help in advance.

Otto

Thanks for your explanation very interesting to read some different application. My application i have wrote in VBA with access. The datalogger is listinging to three tcp/ip-serial converters.  It's three weight scales connected to it. Since i am only getting a weight string from the scale i have made a interface that compares the weight and checks if it is within tolerance. Then i have another weight scale on the far end of the building that we just use to weight scrap and my database just adds it all up. Saves alot of time. For that one i use a ACT1000. the other three are BF430's. Honestly i've had better succes with the ACT1000. It's looks very similar to the Moxa. probably same internals. also same Com software with the swiss army knife. The original com port driver probably acts different then the TCP/IP software from Agg. I do like very much the datalogger part from Agg. It seems very stable and has lot's of features. Needless to say, my tcp ports always need to stay open. And after power failure or other glitch it needs to reconnect. That is the part i am worried about. Right now i have handshake issues between the BF430's and the TCP/IP software.

I have never tried to send signals in the other direction like you want to do. The hardware says it's possible. In my case i won;t loose production but valuable recorded data. i will get random measurements about every 1-2 minute. since the ACT1000 is very low cost i am also thinking about getting three more of those.

Good luck with you application

Luis,

thanks for your reply, i am going to try this and wil let you know, i am currently trying to find out why the datalogger software stops by itself. The icon stays down at the bottom but when you point at it it disappears.

One thing you could consider is to try using the com driver for the hardware. I am thinking there is an compatibility issue, but im not done testing yet

Otto

Which is the correct setting to automatically reconnect to the TCP port after the was a problem with the hardware serial converter? I noticed that my devices will not reconnect automatically. The device is not ready to send data. Not until i restart the datalogger software. I assume the hardware device recieves an initial "ready to send" signal.

When changing the settings on the ODBC export plugin it doesn't pull up the correct or full path. When going into ODBC settings via Start/run is does work. Now, when the software tries to write a value to the database the error "incorrect path or file not found". TCP/IP logger runs as service and starts automatic. My database is located on a network drive. Does the logger software open up a different version ODBC settings? The network path is there and works fine. Only ODBC via the software has issues with it.
please help.
Thanks,
Otto