Access -> mysql problem

[Andrew Threlfall]

Whenever I try to export a table from Access 2000to mysql I get the
following error:

"ODBC --call failed [Microsoft][ODBC Driver Manager (#0)"

I'm using myodbc.dll version 2.5.31.00
I have dowloaded and installed: MDAC 2.5 RTM (2.50.4403.12) and the MDAC
Component Checker confirms this (although there was the odd error that
MDAC CC reported, mainly FileVersion mismatchs - is this normal?)

I've also set up the privilages on mysql by using:
GRANT ALL PRIVILEGES ON *.* TO xxx@"%"
           IDENTIFIED BY 'xxxxxxxx' WITH GRANT OPTION;

If I use ODBC to trace the connection, near the end of the log file I get:
 "MSACCESS        xxxxxx-ffe83fd1	ENTER SQLExecDirectW 
		HSTMT               07FB11DC
		WCHAR *             0x02655DF8 [      -3] "CREATE TABLE (
varchar(50), varchar(50))\ 0"
		SDWORD                    -3

MSACCESS        xxxxxxx-ffe83fd1	EXIT  SQLExecDirectW  with return
code -1 (SQL_ERROR)
		HSTMT               07FB11DC
		WCHAR *             0x02655DF8 [      -3] "CREATE TABLE (
varchar(50), varchar(50))\ 0"
		SDWORD                    -3

		DIAG [42000] [TCX][MyODBC]You have an error in your SQL
syntax near '( varchar(50), varchar(50))' at line 1 (1064)
"

I can see the tables etc, and do admin via mysqlgui, and can import the
table data from the mysql database to MS Access, but cannot use Access to
create and export tables..

What am I doing wrong?

Thanks.

-- 
Andrew