› PLCGurus.NET Live & Interactive Forum › PLC Questions and Answers › General Automation Questions › Data base (microsoft access , ingear logix and Allen bradley compact logix
- This topic has 2 replies, 3 voices, and was last updated 4 years, 8 months ago by
Stixoffire.
- AuthorPosts
- June 16, 2018 at 7:25 am #2446
ANIL
ParticipantKarma: 12Rank: Padawanhere i’m using Ingear drivers for plc and VB communications. now i want to make database in access. can anyone help ?
June 16, 2018 at 9:57 am #2448tfgmedia_admin
KeymasterI would recommend using SQL Server Express edition versus Access as your backend data store. Then you can use Linq to SQL statements in VB to read/write from your database. I personally have not deployed Access in a production environment. Access is more of a personal DB in my opinion.
March 22, 2019 at 4:30 am #3830Stixoffire
ParticipantKarma: 172Rank: JediAs Fred said : Use a real Database.
MySQL, SQLite, MS SQL compact edition – however you must consider what data you are collecting and how much of it in order to make a proper selection as there are size limitations.. also SQL Compact edition has some other limitations as to connectivity, so be careful.You mention VB , but I am not sure what flavor you really mean .. VBA, VB, VB.NET
VB.NET you have some pretty powerful capabilities (Although I started with VB.NET , I prefer to write in C# just more fluid, intuitive and a larger collection of online examples and community of how to do this or that ..) - AuthorPosts
- You must be logged in to reply to this topic.