By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,478 Members | 1,585 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,478 IT Pros & Developers. It's quick & easy.

Using Access and MySQL over Internet

P: 2
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
Share this question for a faster answer!
Share on Google+

Post your reply

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