I’ve searched the web and this site and have found out it’s possible to connect a MS Access front end to a mysql back end. I am interested in taking my current database which is already split and change it to an access FE/ mysql BE.
Since I already have a split database, I downloaded a program that will convert my access database (Tables) to mysql. Now I am confused to where I can actually host my mysql database and access it remotely. My current web hosting company, does not allow remote connections to mysql databases, and a few others I’ve researched do not allow it either.
If anyone knows of a hosting service that allows for remote connections (free or paid) I would be greatly appreciative. Currently I have not been able to able test this format out because I don’t know where I can host my mysql database and I have no server. I am interested in this setup (Access FE/ mysql BE) so that I can access the same data wherever the FE is installed and not just on a local network. Thanks!
Since I already have a split database, I downloaded a program that will convert my access database (Tables) to mysql. Now I am confused to where I can actually host my mysql database and access it remotely. My current web hosting company, does not allow remote connections to mysql databases, and a few others I’ve researched do not allow it either.
If anyone knows of a hosting service that allows for remote connections (free or paid) I would be greatly appreciative. Currently I have not been able to able test this format out because I don’t know where I can host my mysql database and I have no server. I am interested in this setup (Access FE/ mysql BE) so that I can access the same data wherever the FE is installed and not just on a local network. Thanks!