Data base (microsoft access , ingear logix and Allen bradley compact logix

Home PLCGurus.NET Live & Interactive Forum PLC Questions and Answers General Automation Questions Data base (microsoft access , ingear logix and Allen bradley compact logix

https://www.linkev.com/?a_fid=ics-eng

This topic contains 2 replies, has 3 voices, and was last updated by Ken S Ken S 7 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #2446
    Kumar KUMAR
    Kumar KUMAR
    Participant
    • Topics: 1
    • Replies: 0
    • Total Posts: 1
    Karma: 12
    Rank: Padawan

    here i’m using Ingear drivers for plc and VB communications. now i want to make database in access. can anyone help ?

    #2448
    Fred Graham
    Fred Graham
    Keymaster
    • Topics: 13
    • Replies: 158
    • Total Posts: 171

    I 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.

    #3830
    Ken S
    Ken S
    Participant
    • Topics: 3
    • Replies: 14
    • Total Posts: 17
    Karma: 35
    Rank: Padawan

    As 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 ..)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login Register