We have been informed by our web hosting site that we cannot connect
remotely to our mysql database using any kind of connection other than a
script from
a web page or phpMyAdmin.  It is our intent to have our data stored in a
mysql
database on the web and use MS Access as the front end to the database.

Our reasons are - we have an existing Access database with a small number of
users at different locations that need to be entering data, running reports
and queries. We also have a large number of agencies that would hit the
database.  It was our intent to migrate the data tables to mysql and leave
MS Access as the front end. When we asked our web host about this, they
responded this way:
________
Due to security concerns you would not be able to connect to our mysql
server thru an external terminal directly as a mysql client. You would
be able to use mysql services only thru Web sevices i.e either thru php
scripts or thru phpmyadmin in Control panel-->Advanced Menu-->Sql
Databases
_____

My questions are - Is this true of all web hosts or just the one we are
using? Our current hosting plan is a shared hosting plan.  Do we have to
have a dedicated database server to do this?  Knowing that  we want to keep
MS Access as the front end, are there other options we have not explored?




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to