Again I'll suggest posting the body of the SQL statement into Access, this will show you whats wrong.

The message you have supplied, suggests that you have either used a reserved word, or used the wrong symbol eg a coma where it shouldn't be.