Problem with Import or Linked Tables with MySql
- From: cypher_key@xxxxxxxxxxx
- Date: Wed, 18 Jul 2007 23:23:48 -0700
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
.
- Prev by Date: Re: Correct mask to import date from .txt file?
- Next by Date: El Madrid va a po iniesta
- Previous by thread: Re: How do I open an access Database file sent in e-mail?
- Next by thread: El Madrid va a po iniesta
- Index(es):