Connecting MS Access FE to mysql phpmyadmin with VPN

[nector]

I'm having some challenges connecting my MS Access front end to mysql phpmyadmin using VPN , but if I use the public IP address everything works very well. The only challenge with the public IP address is that most of the users use the phone hot spots and keep on switching location as a result the IP Address also keep on changing , hence the requirement to put everyone VPN. How is it done to achieve the connection aforementioned above.

If the was a way to make the public IP address static the that was going to okay, asking the IP provider for static public IP address they seam not willing.

 

[Uncle Gizmo]

I note your question has not yet received a reply hence I am bumping it up the list for a second look ....

 

[Minty]

Some Providers will provide static IP but remember it will only be for that site.
A VPN can do this but will still only work for one site at a time, if people are using mobile hotspots, they would (I think) need to be connected to the same network/VPN.

 

[cheekybuddha]

I'm having some challenges connecting my MS Access front end to mysql phpmyadmin

phpMyAdmin is a web-based interface program for administering MySQL databases.

Normally you would connect Access directly to the MySQL database and use it as the interface interface, not connect to another interface program.

What are you actually trying to do?