If you are not big company or have a big site storing many data Just use MSAcess but for more efficiency, fast and easy to use go wit MySQL
MS Access database is more suitable for desktop use with a small number of users accessing it simultaneously. One reason you might choose to use Microsoft Access over SQL Serve it is having more compatibility then sql
So is MS SQL Server. Compatibility with what? Any language I can use to connect to an Access database I can use to connect to an MS SQL Server database. My only reason for preferring Access in a few very limited cases is that I don't know how to create an MS SQL Server database on the fly (but I could learn if I had to).
Definitely mySQL since it is free and has tons of users. Regarding disk space, it will only depend on your application. I suggest you get a bit more just in case.
Although I've got quite a lot of experience with php and (M/My)SQL, I only used both within an online php script. These last few months I bought an option with my webhost to access the remote database via ODBC via my homePC. I use MS Access (linked tables) on my PC, just because it's very easy to make new reports / forms / querys / ... And, in principle, it should work, shouldn't it? And it does... most of the time, however there very, very often errors. Most of the time I can solve these just by closing and re-openinging Access, but there have to be better solutions for this. can you connect to a MySQL database in another (better) way.
Who told you that lie? You can use any database you can access when you develop a website. There's no problem using MS Access, MS SQL, Oracle, etc. - I've used them all for websites. With most hosting companies, you're only given a choice of MySQL with Linux hosting and MS SQL with Windows hosting, but that has nothing to do with whether a site can use a different database. That would be like saying that bvecause there's a Chevy dealer in your town, but no Ford dealer, that you can only drive Chevys in your town. Availability and ability aren't the same thing.
MySQL is best as compared to MS Access. But if it's small sized application, better use MS Access.. and if it's big, then opt for MySql thanks.................................
Ms Access is not used that much in web applications due to the security / file based storage and it can be a lot slower to query from your code. Really you would want to migrate that data into MySQL or MsSQL. Deciding on which one to use it really based on what your application will do Just my two cents!