Multiple users using MySQL for Excel

[Ignacio Cruz]

Hello. It's my first post in the forum so hi everyone! I have been a lurker trying to learn more information about MySQL for Excel. About me:

Recent college grad and a Navy veteran with a degree in Information Systems. Wanted to focus more in the database field. I have done some small projects in MySQL and SQL Server in college.

Now onto my question: I recently found a job as a Junior Database for a small company that relies mostly on Excel and VBA, but the company want to move away from storing non-relational database to a more powerful relational database such as MySQL. The main thing is to be able to use Excel with multiple users that can edit. That's when I stumbled on MySQL for Excel. Is it possible to have multiple editors/users? I can also propose Access as a frontend and MySQL as a backend database. Like I said, the company relies mostly on Excel right now but it is becoming a problem, therefore we want to move into a more reliable database system. If MySQL for Excel works with multiple users, that would be winderful. If not, then obviously I would have to find something else. I know Access has the ability to do multiple editors.