Since a month, i'm working for a big company in France. They asked me to make a application manage their plannings. I devellopped something not so bad using their existant Access database and VB.net. The problem is that in a few months, the application will maybe be used by 70 workers while today only 10 use it. So i did a lot of researches, and i read that Access could not support more that 20 connection in the same time. Firts, is that true ? What do I risk with an Access database for 70 workers ? And then, what do you think of MySQL in my case ? The application won't be connect on internet, only on intranet. I took a very long time to connect my application to MySQL, but now i don't know how to connect the application in intranet. In fact i'm a bit lost with the choice of my SGDB.
I'm sorry for my English and my bad explanations but i'm french and i didn't find the answers to my questions in french forums.
Thanks to those who will help me.
MySql can handle very large projects, it's stable, updated and free, so I think you shouldn't think to go on with Access.
Connecting to MySql will be quite easy: include MySql.Data.dll and change db connection string, it's easy and you'll find a lot of examples on internet.
If your app should only talk with db in intranet, simply install MySql on a server and connect your app using server ip and port.