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