absurd queries made from myodbc

[joshua bacher]

hi,

i have a problem with the following configuration:

MySQL 3.23.55
MyODBC 3.51
MS Access 97
running on MS Win 2K
all service packs installed
newest MDAC installed.

the point ist, that i ported data from access to mysql. now we want the old access frontend to work over the new mysql situation. therefore we installed the MyODBC Driver.

now i have a subformular in Access with following query outputfrom the SQL-View of access:

SELECT tbl_chimps.code, [Forms]![frm_checksheets]![frm_observations1].[Form]![txtGroup_ID] AS group_ID
FROM tbl_chimps
WHERE (((tbl_chimps.code)
In (
SELECT distinct(chimp_code) FROM tbl_groups WHERE group_id =
[Forms]![frm_checksheets]![frm_observations1].[Form]![txtGroup_ID]))
);

running it, produces an 'ODBC--fail' error message in Access.

so i started watching the MyODBC log.
and recognized the query being truely absurd. its not an MySQL standard.

here it is:
MSACCESS 68c-680 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 0A962030
UCHAR * 0x0EFE1190 [ -3] "SELECT `code` FROM `chimps` WHERE ((`chimps`.`code` )= ANY (SELECT DISTINCT `groups`.`chimp_code` FROM `groups` WHERE (`groups`.`group_ID` = ? ) ))\ 0" SDWORD -3

now the part from mysql log:
SELECT `code` FROM `chimps` WHERE ((`chimps`.`code` )= ANY (SELECT DISTINCT `groups`.`chimp_code` FROM `groups` WHERE (`groups`.`group_ID` = 64 ) ));

this is not MySQL. But what is this and how can i get along with this error?

i guess, it has to be an error from MyODBC, isn't it?

thx for every idea you have!

greets
joshua bacher