Problem with Import or Linked Tables with MySql

[cypher_key]

I'm tried to import data from a MySQL database in to MS Access 2000.

The error I'm getting is:
ODBC--call failed
[MySQL][ODBC 3.51 Driver][mysqld-5.0.15]Access denied for user
'user'@'%' to database 'mysql' (#1044)

My ODBC data source is setup correctly because I'm able to import data
from a MySQL table in to Excel using "Get External Data", "New
Database Query". Also the "Test" button returns Success in the ODBC
configuration.

I have set the database field under the login tab in the ODBC
Configuration. I also tried setting the Initial Command to "use mydb".

I'm not sure why Access is trying to access the mysql database table.
I don't have access to that table because I'm not the admin for the
MySQL table.

I haven't figured out how to produce a debug log. If I do I'll post it
here.

Has anyone else encountered this problem?

thanks,

Aaron

 

[wiguna]

I'm using Access 2003 with MySQL 5.1 and configure the connection like this
(it works!):

Set conIni = New ADODB.Connection

conIni.ConnectionString = "MSDASQL;DRIVER=MySQL ODBC 3.51
Driver;DATABASE=repronet;DSN=ReProNet;UID=user;PWD=password;"
conIni.Open

See that it has to use MSDASQL. Good luck!

Donny A. Wiguna