[AccessD] Connecting to MySQL across Internet **Anybody???**

Ok, I'll take a shot, but this is a strict AFAIK, maybe someone else
knows better ...

Assuming your Access application is running completely on the client PC
(that's why you asked this list), that is, no ASP/IIS going on; then the
only way, and its not light, would be MySQL ODBC installed on the
client, then you can instantiate an ADO connection only when needed.

This is an area where a Web Service could come into play; that would be
lighter than ODBC, but much heavier on your development time (web server
development to expose the service, application development to request
the service, etc, etc)

Hth
Steve




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Gracie
Sent: Thursday, September 16, 2004 7:17 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Connecting to MySQL across Internet
**Anybody???**


Hello,
 I have a program that may need to connect to a MySQL database across
the internet, on the fly. It's only for a very small portion of the
program so it may or may not be needed to be utilized by many users.

 So basically what is the best (lightest) way to make this connection on
the fly, and only when needed? I think I will be looking at 3-4 tables
MAX.


To add,... it's an A2K .mdb

Robert Gracie
www.servicexp.com





-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com