The code is copy and pasted from Access, it runs the query on Access fine.

I'm looking up what vbCRLFs are, I'm not sure what that is.