|
Home > Archive > MySQL ODBC Connector > January 2006 > myODBC won't link tables to MS Access but VBA works???
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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? unsu...sie.nctu.edu.tw
| |
|
| 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 & #91;mailto:thomasj@f
iberpipe.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? unsu...sie.nctu.edu.tw
|
|
|
|
|