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.
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.
