As ForumAccount stated, you are missing the closing parenthesis in your Command string:
vb Code:
Dim command As New OleDbCommand("INSERT INTO PMTStatus (EquipmentType, TAG, Descriptor, Status1, Status2, DateChanged, Comments, UserID) VALUES (@EquipmentType, @TAG, @Descriptor, @Status1, @Status2, @DateChanged, @Comments, @UserID)", connectionSQL)






Reply With Quote