One of the problems with MSAccess is that the SQL it creates sometimes isn't recognised as a valid SQL statement, either in MySQL (or MSSQL).
Have you tried pasting the sql from access directly into phpmyadmin ? you will probably find it doesn't work