I don't have MS Access to test this right now, but it could be that Access doesn't like the trailing semicolon at the end of your query.