05-23-2016 10:02 AM
Howdy! My next project will consist of storing product test data onto a server. Right now I'm looking up the pros and cons of using Microsoft Access vs something like MySQL or HeidiSQL. This is my first time messing with a database like this, so I need any helpful input. From what I've read, SQL is better for a large amount of data, which it eventually will be, but Access is better at setting up the ability to print out nice reports, which will be needed.
So please let me know which one you recommend, and why. Thanks!!
05-23-2016 11:28 AM
Access is a 1 person at a time database. Which means if you have it open, nobody else can get to the data. This could be a serious issue (at least it became one with some applications I was involved in). I would go with SQL. You can make your own programs to do reporting if you really need to. Or you could use DIAdem.
05-23-2016 11:40 AM
Whoa...I didn't know that about Access and, yes, that would be a problem. Thanks for the info!!