Using Access and MySQL over Internet

[roychong]

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

http://www.nusphere.com/products/li..._mysql_odbc.htm

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.

Cheers!
roy

[ashishm]

Please take a Global IP. or
Deploy Database on a Host Service Provider.

[gwalters]

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