Access to MySql

[Ben]

does any one have any lead or information on connecting to MySql using
Access? Thanks.

Ben

 

[SA]

Ben:

You need to connect to MySQL using ODBC and linked tables from an MDB
database (or connnecting to a SQL Server using ODBC if you are using an ADP
db). You can get the "connector" which is MySQL parleance for ODBC from the
mysql.com web site.

 

[Van T. Dinh]

Steve

AFAIK, ADP is exclusively used with MS-SQL Server Back-End and not other
database engine.

 

[SA]

Van:

1.) Ben did not indicate that he was using an ADP in his post.

2.) You can use an mdb db with any ODBC connection to link table into an
Access db.

3.) Even if you were using an ADP and had ODBC capabilities for MySQL, you
would set up a SQL server db with a linked server on the SQL Server using
ODBC to link to the MySQL tables. (Although why you'd want to do that is
beyond me, its simply is possible.)

Steve Arbaugh
MS Access MVP
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

 

[Van T. Dinh]

Hi Steve

(points as your points)

1. Ben did not but you did ... That's why I was wondering ...

OK. I think in the parenthesized clause of your previous post, you meant
linking the Tables in the MySQL database to an MS-SQL Server database using
ODBC and then use an ADP on the MS-SQL Server database? (which leads to
your point 3)

2. Agreed, no probs with this.

3. I wouldn't use ADP in this case, certainly not MySQL --> MS-SQL
Server --> ADP. In fact, I hardly use ADP, even for MS-SQL Server databases
(as per m.p.m.a newsgroup).