jdbc:odbc insert error fails with code -3502

[Jon Dornback]

I am calling a preparedstatement that performs inserts on a single table in an access database. However, the insert fails and I can't figure out why - any help is most appreciated. I also tried this as a batch, and that didn't work either.

// code that inserts in to the database:
PreparedStatement addFee = cnxn.prepareStatement("INSERT INTO RegistrationFee(meetingID,feeType,regularFee,earlyFee,description,order)
    VALUES("+meetingID+",?,?,?,?,?)");
// regFees is an array that has been initialized
         for(int k=0;k<regFees.length;k++){
            addFee.setString(1,regFees[k].getFeeType());
            addFee.setInt(2,regFees[k].getRegularFee());
            addFee.setInt(3,regFees[k].getEarlyFee());
            addFee.setString(4,regFees[k].getDescription());
            addFee.setInt(5,regFees[k].getOrder());
            addFee.executeUpdate();
         }
// generates this error:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
error code: -3502
sql state: 37000
  

I have other statements similar to this that work fine, and the values used as parameters are of the correct type. Any suggestions?
[ November 19, 2002: Message edited by: Jon Dornback ]

[Jon Dornback]

I found the problem. In my infinite wisdom, I had used the SQL reserved word "order" as a column name.