Re: MySQL Connector/ODBC 3.51.17 fails to work with MS Access 2002
Jim Winstead <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
On Wed, Jul 18, 2007 at 10:08:01AM -0400, Jerry Schwartz wrote:
> I was unable to get 3.51.17 to work with MS Access 2002. I installed it from
> the msi bundle. The connector passes a test when creating or configuring a
> System DSN, but when I try to link tables from MS Access I get an error
> message:
>
> [MySQL][ODBC 3.51 Driver][mysqld-4.1.22-standard]Access denied for user
> 'readonly'@'%' to database 'mysql' (#1044)
>
> The same user with the same password has no trouble accessing the
> appropriate database ('giiexpr_db') using the mysql CLI from the same
> computer.
This is a side-effect of the fix for Bug #26934, and the workaround is
to enable SELECT access to the mysql database, as you noted.
A fix for this problem will be in 3.51.18.
Jim Winstead
MySQL Inc.
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/[email protected]