Here's a fast way of getting to the source of the matter that I like to use:

Assign your SQL to a variable, like szSQL = "INSERT ..."

Set a break point after you assign it and in the immediate window type debug.print szSQL or ? szSQL

You should see your complete statment. Copy and paste it as a new query in Access and run it there to see what's going on...

Just from looking it it it looks OK except you may need a space before VALUES