Originally posted by Nic
MySQL is an excellent open source database that is very popular. Its way more sophisticated than MS Access. I think the point that was being made is that its possibly more sophisticated than required and would be quite difficult for a novice user to design, install and configure (just a guess).
More like I was going to say right now. Yeah, MySQL works... sure... but then again, they've got to learn it, it will be tough. And if one learns MySQL, one has to learn PHP.
For remote access on internet or intranet (with whatever security and access options you want): MySQL.
For access with a single computer that has all the programs stored locally: MS Access.
It's more of how much time you want to spend.
Option 1:
- Learn HTML, then PHP, then MySQL, then Apache web server, and get some experience over a long period of time. Ideal for remote access. Then use MySQL databases.
Option 2:
- Learn the easy GUI interface of a program for local use only and faster to learn. Then use MS Access.
I've finished learning PHP without the use of MySQL and I'm getting into MySQL, it isn't that hard though, but I'm just a fast learner who loves on-hands learning/training. After that, I'm jumping into Apache. (I have a HUGE book on PHP, MySQL, and Apache).
Originally posted by Phantasm66
And to ensure that its only that intended person that can access the data, we could use mod_auth_mysql to keep the username and password as part of the database we are serving.
Give him a MySQL lesson while you're at it. :grinthumb