469,951 Members | 2,622 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,951 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
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
Feb 24 '06 #1
0 2133

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.