We're looking for a trending utility which can be used in conjunction with an MS Access 2002 database. The two main things we need to be able to do are zoom in on sections of the trend and allow operators to enter which batch they wish to view the trend for. This will then cross reference start/end times stored in one table with the actual trend data in another table. There's only 8 parameters involved in this so highly configurable pen selection is not needed. ActiveX would be preferable as Access forms are the primary user interface on the PC.

Any suggestion appreciated.

Thanks

Steve

 

You could have a look at DAQFactory from Azeotech. They offer an ActiveX component which will probably do what you want. see www.azeotech.com

 

Steve,

The Office Web Components (OWC v10+) are included with you Office XP package. A little knowledge of the methods, properties and events will get you
going. If you are using IIS 5/6 and IE 5/6 you can build charts "on the fly" and send gifs in ASP/HTML pages. The MSDN library has working examples. I'm pulling real-time charts out of
SQL Server PLC data, but will work with Access too.

 

Dear Steve,

Our product automationX is real-time software that has ODBC classes for database access and a complete trending solution. We also have a batch
management package. Depending on how may points you'll be trending (e.g. greater than 30) the product might be a good fit.

Regards,

Paul Jager, President
automationX Industrial Solutions
www.mnrcan.com
[email protected]
(250) 724-1402

 

Check out Canary Labs. Been around forever, also Iconics - trendworx, but requires OPC drivers

Cheers from: Jeremy Pollard, CET The Crazy Canuckian!
Integration and Automation Training, Consulting, and Software

Control Design Column
http://www.linkpath.com/index2gisufrm.php3?tempCode=CON&onlineIssue=true&mem
_sess=d8734688500ceb501ce5610f4a530004&speed=high

On The Web - http://www.tsuonline.com

PLCopen North America - [email protected]
http://www.PLCopen.org

 

Hi Steve:

If your machine has an AB PLC5 or SLC500, you can just add analog input cards or some may already exist. Then you can use Allen Bradley's trending software to link to MS Access. (A lot of times, the analog plot points are already being input to the PLC.)

On the web at http://www.bin95.com