I have developed a database using MS Access 2013 front end with a MySQL back end on my Windows 7 Pro 64 bit PC and now want to set up the production version for 2 remote workers.
So far I've managed to upload the back end to the web server and can connect to it from my PC using MySQL Workbench but I'm mystified as to how I now go about setting up the users.
They will be running Windows 7 PC's where the Access 2013 front ends will be located but what do I need to do to link the tables from their PC's to the remote server?
From what I can gather so far I think I need to set up a system DSN with the connection string, then link the tables? If that's the case then do I need to do this on each of the PC's and link the tables individually or is there a way of just having a common DSN?
Any help much appreciated.