469,923 Members | 1,320 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,923 developers. It's quick & easy.

Using Access and MySQL over Internet

Hi everyone,

I'm keen to use Access as a client application to access data from a MySQL database. The reasons are Access for its strength in reports creation and MySQL for its stability and scalability. I also intend to site the MySQL database with a web hosting service provider. This means I'll be trying to access the database over the Internet using MS Access.

I have managed to access MySQL using MS Access through MyODBC driver and get everything running well. But they are all siting in the same machine. To place the database over at the web hosting service provider end and access it will be my next step.

This is where i need help. When I setup my database at MySQL i need to grant access rights to users by using the SQL command "GRANT". The command would require the IP address of the accessing party which in this case is the machine that house my MS Access client. The problem is that my machine is accessing internet via an Internet Service Provider that assigns dynamic IP address to users. Being dynamic I will have problem typing an IP address for the accessing client when setting up at MySQL database. What can be done?

More info about setting up the Access/MySQL combo can be found at

Hope I'm not confusing anyone. But if i do, pls drop me a line. I'll clarify.

And any thanks to anyone keen to help.

Feb 24 '06 #1
2 3475
Please take a Global IP. or
Deploy Database on a Host Service Provider.
Feb 25 '06 #2
You can do either of these

mysql > grant all priviledges on mydata.* to username@IP identified by "password";
mysql > grant all priviledges on mydata.* to username identified by "password";

My question is what would be the specs for the internet connection as far as
speed to get the desired performance. I've done the normal broad band connection between SC and Calif and it was terrible. Any body know more about this??
Nov 13 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Otto Krüse | last post: by
2 posts views Thread by areejan2000 | last post: by
49 posts views Thread by Mell via AccessMonster.com | last post: by
3 posts views Thread by Kevin Killion | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.