My current team of 20 people use an Access database front end on their desktop. The backend of the access database is on a network drive. I have been asked to create a Access database front end with MySQL as the back end. I have installed the MySQL workbench and the ODBC connector on my computer. I have created the schema and tables and I have connected the front end of the database connected to the MySQL table I created in workbench.
My questions are:
- How do I deploy this for the team to use. I believe I can move the front end of the Access database to the network drive and the team can copy it to their desktop. But what do I do about the MySQL backend? Where should it be placed?
- Does the team need to have the ODBC connector installed in their computers?
- Should I move the MySQL workbench to the network drive?
PS: I am a new developer and just learning about databases and I am only familiar with Access databases.