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@xxxxxxxxxxx