What may have thrown you here is something that has thrown me often. ACCESS (well ACCESS 2003 anyway) is more permissive with double quotes when you create queries within the database than when you submit them across an ODBC connection. For example, a query ending with something like .... and...