Access Database

How do I get an Access database to automaticlly insert a new row for collecting data off of an AB PLC? Please help, I can't take the pressure anymore...

Trav

Trav,

Are you using RSSQL software?

Perhaps if you can give some more details someone can help. I will be following this post as I need to do something similar soon.

Just complain about crummy Rockwell software docs, that helps!

Best of luck,
Roy

I can tell you how to use Visual Basic Express (the free version) to read data from a SLC and write it to an Access database table.

Which PLC model? What comm link to the PLC do you have?

I assume that you have a PC connected to the PLC and you are using RSView SE. First of all you will require either RSLinx Pro or a third party OPC server (Kepware). Why use Access? Microsoft SQL Express is free and probably could do enough for your project. Whatever DB you are using, you will then have to write some VBA, VBscript, etc. to read the data from the OPC server and write it into the the database. (This only requires a few lines of code to enter data into a DB.) It would probably be better to use RSView as the front end to provide a GUI interface (this means RSLinx Classic/Factory Talk can be used) and the data could be written to a SQL DB (SQL Express) using RSView's built in VBA.

Basically, you need to provide more information about the project.

Kevin

Check out FactorySQL or other SQL data logging utilities. Writing custom code to re-invent such a common task makes no sense.

http://www.inductiveautomation.com/products/factorysql

----
Nathan Boeger
http://notanotherindustrialblog.blogspot.com
Inductive Automation
"Total SCADA Freedom"