mysql

[Ninjakreborn]

I know about phpadmin, is msaccess mysql too, if I create a database and use it and connect to it using msaccess, I am unsure of this, I know phpadmin is my sql, and it's written in php, but I am still figuring out, a lot of people tell me not to us msaccess, what are the reasons, it's the only reason is because I already have it on my computer from office 2003, I thought i was convenient. I have had other web developers telling me they have multi hundred thousand databases on there server done in ms access, what is so bad about it, and why does everyone here and other places tell me to stay away from it.

[AndyB]

One set of opinions - [a href=\"http://www.daniweb.com/techtalkforums/thread5712.html\" target=\"_blank\"]http://www.daniweb.com/techtalkforums/thread5712.html[/a]

[fenway]

There are a number of reasons:

-any type of client can access a MySQL database, and it is easy to have it accessible over the web, and all are free

-MySQL is designed to handle many simultaneous users/clients.

-MySQL can eaily support large databases

-MySQL has proper login credentials to a DB, whereas Access is just as bad as the rest of the MS Office suite.

-Unlike Access, data storage is centralized for all users, so backups are easy. This also means that disk storage requirements are isolated to the server itself.

-MySQL is free, and will always stay this way, in some form or another.

-MySQL doesn't limit your choice of OS.

[Ninjakreborn]

PERFECT, more than what I was hoping for thanks for the answer.