Access front end with a hosted MySQL backend

[Jamie Risk]

Hello all,

I've need to access information on a MySQL server but would like to use
Access as a front end.

Is it possible to use Access as a front end to a web based SQL database? Is
this even reasonable to try?

At first I'm content knowing how to add/delete/view/query enteries in
existing tables, but would also like to know if tables on the hosted
database could be created using Access as well.

- Jamie

 

[J. Clay]

My inclination is to so no this is not possible. Most web hosts will NOT
allow external applications access to databases hosted within their "Walls".
This would be too big of a security risk. The only option I can see is to
set up some type of web service using XML and/or SOAP to return data from
the database to call from an external application.

In addition, the speed would be an issue and you would need to be highly
optimized. You would want to make sure you were pulling the minimal amount
of data possible in each call to the database.

Jim

 

[C. Walters]

Download the ODBC driver from the MySQL website. I've
done this and it works beautifuuly. I've had to create
the tables in MySQL, but have been very successful at
uploading data and running queries.

 

[J. Clay]

Learn something new every day!

Althoug I would still be concerned about security and would be suprised that
a web host would allow this. I know the ones I deal with are VERY concerned
about security and would never allow this.

Jim

 

[joe.stern]

discountASP.net offers limited access to hosted MySQL and MS SQL Server
databases. However, even with very small amounts of data, I found the
speed to be unacceptable.