Note that MS Access likes a slightly different syntax for its SQL when controlled through ODBC (and thus, through DBI), than it does through the interactive query interface ("query builder"): through ODBC it likes a more standardized SQL. That may occasionally bite you.

And Corion is right, semicolons in SQL statements often make things not work.