Problem with Import or Linked Tables with MySql

C

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
 
W

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top