Okay, I'm pulling my hair out. I'm getting NO error on the following code:

Dim cmd As New OleDb.OleDbCommand("CREATE TABLE [" + empTableName + "] ([ID] DOUBLE, " & _
                                                                                "[LnameFname] TEXT(255), " & _
                                                                                "[Location] TEXT(255), " & _
                                                                                "[SalaryOld] DOUBLE, " & _
                                                                                "[FtePercentage] DOUBLE, " & _
                                                                                "[EvalScore] DOUBLE, " & _
                                                                                "[EvalUnitsPerm] DOUBLE, " & _
                                                                                "[EvalUnitsStipend] DOUBLE, " & _
                                                                                "[EvalIncreasePerm] DOUBLE, " & _
                                                                                "[EvalIncreaseStipend] DOUBLE, " & _
                                                                                "[ExperienceDegreeUnits] DOUBLE, " & _
                                                                                "[ExperienceDegreeIncrease] DOUBLE, " & _
                                                                                "[AcademicNeedsUnitsPerm] DOUBLE, " & _
                                                                                "[AcademicNeedsUnitsStipend] DOUBLE, " & _
                                                                                "[AcademicNeedsIncreasePerm] DOUBLE, " & _
                                                                                "[AcademicNeedsIncreaseStipend] DOUBLE, " & _
                                                                                "[LeadershipUnits] DOUBLE, " & _
                                                                                "[LeadershipIncrease] DOUBLE, " & _
                                                                                "[Classification] TEXT(255), " & _
                                                                                "[Notes] TEXT(255), " & _
                                                                                "[SalaryIncrease] DOUBLE, " & _
                                                                                "[Stipend] DOUBLE, " & _
                                                                                "[IndividualTotalUnitsPerm] DOUBLE, " & _
                                                                                "[IndividualTotalUnitsStipend] DOUBLE, " & _
                                                                                "[SalaryNew] DOUBLE, " & _
                                                                                "[MeetsAcademicNeeds] BIT)", frmMain.con)


                frmMain.con.Open()
                cmd.ExecuteNonQuery()
                frmMain.con.Close()

However, right after that code I use this code and get a syntax error. Can anyone tell me why? Thanks!

Dim cmd2 As New OleDb.OleDbCommand("CREATE TABLE [" + bulkCashAmountsTableName + "] ([ID] DOUBLE, " & _
                                                                                "[TeacherBulkAmountPerm] DOUBLE, " & _
                                                                                "[TeacherTotalUnitsPerm] DOUBLE, " & _
                                                                                "[TeacherUnitValuePerm] DOUBLE, " & _
                                                                                "[TeacherBulkAmountStipend] DOUBLE, " & _
                                                                                "[TeacherTotalUnitsStipend] DOUBLE, " & _
                                                                                "[TeacherUnitValueStipend] DOUBLE, " & _
                                                                                "[AdminBulkAmountPerm] DOUBLE, " & _
                                                                                "[AdminTotalUnitsPerm] DOUBLE, " & _
                                                                                "[AdminUnitValuePerm] DOUBLE, " & _
                                                                                "[AdminBulkAmountStipend] DOUBLE, " & _
                                                                                "[AdminTotalUnitsStipend] DOUBLE, " & _
                                                                                "[AdminUnitValueStipend] DOUBLE, " & _
                                                                                "[ClassifiedBulkAmountPerm] DOUBLE, " & _
                                                                                "[ClassifiedTotalUnitsPerm] DOUBLE, " & _
                                                                                "[ClassifiedUnitValuePerm] DOUBLE), " & _
                                                                                "[ClassifiedBulkAmountStipend] DOUBLE, " & _
                                                                                "[ClassifiedTotalUnitsStipend] DOUBLE, " & _
                                                                                "[ClassifiedUnitValueStipend] DOUBLE)", frmMain.con)

                frmMain.con.Open()
                cmd2.ExecuteNonQuery()
                frmMain.con.Close()
This question has already been answered. Start a new discussion instead.