myODBC won"t link tables to MS Access but VBA works???

Win2K Pro, Access 2003, MDAC 2.7

Latest mySQL installed fine and runs.

MyODBC 3.51 installs.

Cannot link mySQL tables to MS Access mdb via file menu, Get External Data
menu item. Get ODBC failed error.

In VBA, cannot use recordset.AddNew, ... recordset.Update methods. Get
ODBC failed error.

However, using DAO 3.5, VBA will establish connection, drop table, create
table, and add records ONLY with a query defined
(currentdb.createquerydef) and qry.Execute.

Any ideas?

Thanks and have a nice day!

Jim Thomas




--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: myODBC won"t link tables to MS Access but VBA works???

I assume you can test the connection OK from Control Panel?

I am using Access 2003 like this with a local and remote MySQL server of
two different versions but WinXP SP2, MDAC 2.8.

John B.

-----Original Message-----
From: thomasj@fiberpipe.net [mailto:thomasj@fiberpipe.net]=20
Sent: Saturday, 28 January 2006 7:20 AM
To: myodbc@lists.mysql.com
Subject: myODBC won't link tables to MS Access but VBA works???

Win2K Pro, Access 2003, MDAC 2.7

Latest mySQL installed fine and runs.

MyODBC 3.51 installs.

Cannot link mySQL tables to MS Access mdb via file menu, Get External
Data
menu item. Get ODBC failed error.

In VBA, cannot use recordset.AddNew, ... recordset.Update methods. Get
ODBC failed error.

However, using DAO 3.5, VBA will establish connection, drop table,
create
table, and add records ONLY with a query defined
(currentdb.createquerydef) and qry.Execute.

Any ideas?

Thanks and have a nice day!

Jim Thomas





--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg