Connecting to MySql from access

[ahrint]

Hi all,

hope someone can help me with this.

Before we moved webhosting company we could have external access to our MySql database which was great as our MS Access system would periodically pull data from our MySql site (namely customer enquiries which were entered via a form on our website) and dump them in our MS Access live quotes table all automatically.

With our current host (which seems to be the norm from my web-searches) they only allow local access to the MySql system.

My question is, how can I oversome this hurdle without having to move hosting company. I really don't want to move again as it's a real pain.

All suggestions welcome.

ahrint

 

[spacepro]

Ahrint,

Talk to your webhost. Chances are they will not allow access without a dedicated IP. Maybe you will also need to talk to your ISP as well, especially if your ISP IP is dynamically routed.

Your web host should be able to guide you as to the best way forward.

Andy

 

[ahrint]

Thanks Andy,

I'll see what they say.
ahrint