Can anyone post a SIMPLE access file that will retrieve one or two pieces of bit data from a SLC 500.

I've got RSLinx Gateway, and have used DDE in Excel to do this as well as in Visual Basic and C++. I downloaded the sample access program from the download section, but it's got a lot going on in it. Without the correct Topics, it fails anyway.

So I guess what I'm asking for is just a VERY basic access module that will poll one or two peices of data from the PLC and place it in a table. I can figure the rest out from there.

Don't have an access example I can send you, but I did recently post an excel example under Allen Bradley HMI Sample Code which works from a button on an excel sheet. Modifying this code to point to a table entry should be minor work, Check it out and I hope it helps. I did use this same code with access at one time but did not keep a sample.

You can try this one.

http://forums.mrplc.com/index.php?autocom=downloads&showfile=137

Maybe that's the one you downloaded already....



-

WOW! That was an OLD post of mine.

I ended up giving up on this and just wrote the whole collection program in visual basic. From there, I dump it into the db.

Here's one for you though... Does anyone know how to create a live DDE or OPC link in asp? (In case you don't know what that is, it's a vb like langage used for making dynamic websites.) That way, you can pull up CURRENT machine data instead of what you have logged into the db.

(This should really go into a different topic I guess...)

Hey better late than never

Which particular AB controller are you thinking about doing this with?

Mostly SLC 5/05's and micrologix 1500 through ENI mods. I'm talking about custom built applications though, not what you can use through the built in webserver.

Currently I've written all the programs to read through the database which I have updating every 5 minutes or so. It would be nice though to do a quick (where do we stand now) type of application that will allow (from the website) to read the current values or even update the db, or even change process parmeters based on website input...) -This last thing is something I do now, but I load everything into the database then have a vb program insert it in the PLC. (Going from the website would take out the delay...)

Ok, if it was Controllogix I was going to suggest the EWEB module. Does exactly what you are looking for through Asp and Xml. We pages completely custom. Way different than the 1761-NET-ENIW and SLC5/05 but oh well

Don't know about ASP, but you can use OPC with XML.

But take a look at this site: http://www.opcware.com/OPCWare.html

I've never tried it, but they have a free trial version for download.
Full version is about $400.00