I have a database with forms and tables in MS Access. I need to allow
several users in various remote destinations to access the database
and work on it at the same time. The forms include some complex code
and other attributes (like calls to a third party application) that
make it impossible to recreate the forms in
PHP or some other language. From my research so far, the best
solution seems to be to convert the tables to a MySql database, host
the MySql database somewhere, and distribute the "front end" MS Access
application to my users. They will connect directly to the database
via some sort of ODBC connection or other type of connection. This is
the route I want to go, but I can't seem to find a hosting service
that will allow me direct access to the database via the web. They
all want me to create a PHP, ASP, etc front end to access the
database. I need to find a hosting solution to accomidate connecting
to the database directly, or find another path to getting this done
cheaply and easily. That's the other thing - I don't want to create a
VPN because of the complexity, cost, and slow performace I'll get from
people trying to access the database. So, are there hosting solutions
out there that will accomidate this, and if so, what are they? Thanks! |
