View Single Post
Old September 6th, 2011, 01:19 PM   #5
Archie
Member
United States

Archie is offline
 
Join Date: May 2002
Location: Orangeburg, SC
Posts: 1,756
Quote:
Originally Posted by williamlove View Post
I am intrigued. I would like to read/write to a SLC from a VBA procedure in an Access 2010 database. (Iím sure you know that VBA in this case is not VB.net, but is the VBA version 6 that has been around for years.) Is the product suitable for that, or does it require the full VB product? I use Access as the basis for many of my solutions. Thank you.
I tried to do it in Access 2010, but no success. Microsoft Office has yet to adopt easy integration of .NET components.

In my opinion, it's better to use the full Visual Basic environment to retreive values from the PLC and store them in a database. The free version of Visual Basic Express will allow you to connect to an Access database. There are lots of examples on how to do it:

http://msdn.microsoft.com/en-us/vbasic/ff718212
__________________
Expectations lead to disappointment. Appreciation leads to satisfaction.

AdvancedHMI - HMI Software without the license key hassles
  Reply With Quote