mysql - What's wrong with this SQL code? (VBA MS Access)

Question

insertString = "INSERT INTO paymentRecord(paymentEventDate,paymentType,paymentRecordNotes,value,clientID,jobID) 
VALUES (recordDate,recordType,recordNotes,paymentValue,clientID,jobID);"
DoCmd.SetWarnings False
DoCmd.RunSQL insertString
DoCmd.SetWarnings True

This code returns a syntax error and I don't know why. All insert values and columns are correct.

The code is being used in a MS Access front-end with a MySQL database back-end.

Answer 1

You must concatenate the values:

" .. VALUES (" & recordDate & "," & recordType & "," & recordNotes & "," & paymentValue & "," & clientID & "," & jobID)"

Also, the values must be formatted and delimited correctly, for example by using my function CSql.

Even better, use parameters.