Search the Community

Showing results for tags 'access'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Found 6 results

  1. Read/Write Access DB

    I am fairly new on this forum & PLC's, usually i read and get tips from here.I use a RsLogix 5000 PLC software. I am currently working on a project at home that requires me to read from a Access DB. What type of Instruction or method do i go about, initially reading from Access? I know Excel is possible It's an existing system. Add on functionality/feature. I am using a barcode scanner that will link up to a Access DB to verify the barcode is legit and send this info to a different system via PLC/EthernetThe access DB is used because its a older system, it uses that. So it is possible? and guessing from what your stating, its is more involved to get the system working eventually?PLC = A&B 1769-L23-QB1 CompactLogix Controller I am using FactoryTalk View Studio as HMI, do not have SCADA.I have a control logix chassis. Thank you in advance...
  2.  Hellow Mitsubishi Experts    . I want to update my system . My machine have Mitsubishi plc system . Details of plc - CPU FX1n-60MR-001 Expansion Module FX2n-8EYR  . We have two factories .In one factory have this Mitsubishi plc system (LOCAL Location ) .So from other factory (Remote Location ) I want to check some plc data via internet using some interface (Ex visual studio interface )  .It is mean I want to remotely check some data (machine production units ,machine speed and etc )  . I have plc program and plc software .   So what i want to add external modules to this system .?   How can i implement my design ?.   . I m appreciate ur immediate reply .       Thank you.   Tharindu  
  3. Hi I have a big issue with machine user access using loggin and password. There are different levels of login (operator, maintenance and admin) locked with physical key or password. The problem is that whenever any other user sees the password or got the key he can use it later. Is there another efficient way to lock the access and may be record who is logged when and how? Thanks  
  4. Hi, I have a a few substations and I´d like to have a local SCADA in each of them. What is the best scada to use with reasonable price? Does anyone know if there is a solution without the need to have a PC for each substation? Thanx
  5. Here is a recent post that I would like to share. Using Visual Basic 2015 we will log three holding registers from the PLC along with time and date into a Microsoft Access Database. We will log every minute into the database with the information that we collect from the PLC via Modbus TCP (Ethernet). All code will be done and shown so you can implement this in your application with different parameters. The information collected in the database can then be distributed or analyzed in the future. Visual Basic 2015 will be used with the EasyModbusTCP client/server library for .net. We will communicate to an Automation Direct – Do-More PLC. Using the free simulation software of the PLC Designer Software, we will retrieve three values of the Modbus Holding Registers using Modbus TCP. Once we have this information out of the programmable logic controller it will be placed in a Microsoft Access (2010) Database. This will be done by using a SQL command to insert the data. Read the rest of the post... Let me know what you think, Thank you Garry http://accautomation.ca/
  6. http://accautomation.ca/now-you-can-have-robust-data-logging-for-free-part-1/ YouTube overview: https://www.youtube.com/watch?v=6Xa2HYVOxE0 Robust PLC Data LoggerWith traditional loggers, software will read the memory of the PLC and store in a local computer. If the network stops or the PLC communication fails then the logging will stop.Creating a robust PLC data logger allows the communication to be stopped for a period of time without losing any of the data for collection. This is accomplished by storing the data locally on the PLC until communication is restored. All of the data is then read without loss. The amount of time that the connection can be lost will be dependent on the memory size of the PLC and the frequency of the data collected.This series will walk you through the steps to create and implement a robust PLC data logger using the following equipment and hardware. Automation Direct – Do-More – H2-DM1E PLC (Ethernet Modbus TCP)Do-more Designer 1.3 (Simulator instead of PLC mentioned above)Windows based computer running IISVisual Basic 6Regards, Garry http://www.accautomation.ca