MS Access ODBC problem

I need to link some tables from a remote MySql server (ver. 4.1.12) to a MS
Access 2003 db.
I can succesfully connect using both MySql Administrator and MySql Query
Browser.
Even the ODBC Admin test button tells "Success; connection was made".
But when I try to link the tables from within MS Access using the ODBC DSN I
get:
[MySQL][ODBC 3.51 Driver]Access denied for user 'xxx'@'%' to database
'yyy' (#1044)
I searched the Net without results so far. Any help will be really
appreciated.

Thanks,
Bruno

On Wed, 23 Nov 2005 17:43:05 +0100, Bruno wrote:
> I need to link some tables from a remote MySql server (ver. 4.1.12) to a MS
> Access 2003 db.
> I can succesfully connect using both MySql Administrator and MySql Query
> Browser.
> Even the ODBC Admin test button tells "Success; connection was made".
> But when I try to link the tables from within MS Access using the ODBC DSN I
> get:
> [MySQL][ODBC 3.51 Driver]Access denied for user 'xxx'@'%' to database
> 'yyy' (#1044)
> I searched the Net without results so far. Any help will be really
> appreciated.

Check whether Access has user xxx granted authority to database yyy.
Connecting to MySQL and accessing its tables is half the battle; the
error looks like MySQL is having trouble making the connection to
Access.

--
"'I'm not sleeping with a jr. high schooler! I have a life-sized doll that
looks like one.' Uh huh. That sounds SO much less pathetic."
-- Piro's Conscience www.megatokyo.com

Thank you for your answer.
Could you please give me more details on what and where I should check ?
I can access the tables through MySql Query Browser (read and write data, of
course) with the same user I use for ODBC/Access.
Does MySql have a "special" setting for MS Access ?
Bruno


> Check whether Access has user xxx granted authority to database yyy.
> Connecting to MySQL and accessing its tables is half the battle; the
> error looks like MySQL is having trouble making the connection to
> Access.

On Thu, 24 Nov 2005 04:37:31 +0100, Bruno wrote:
> Thank you for your answer.
> Could you please give me more details on what and where I should check ?
> I can access the tables through MySql Query Browser (read and write data, of
> course) with the same user I use for ODBC/Access.
> Does MySql have a "special" setting for MS Access ?
> Bruno
>
>
>> Check whether Access has user xxx granted authority to database yyy.
>> Connecting to MySQL and accessing its tables is half the battle; the
>> error looks like MySQL is having trouble making the connection to
>> Access.

My apologies. I misread the direction of the connection. I'm guessing at
the operation of the ODBC engine a little bit, but many versions of
MySQL have the '%' host mean "Every host *except* localhost", and I
suspect that the ODBC engine is connecting as a localhost service. So
you may need to get a user xxx@localhost user created to match the xxx@%
user.

--
84. I will not have captives of one *** guarded by members of the opposite ***.
--Peter Anspach's list of things to do as an Evil Overlord