28 Sep 2014 by Bernhard Hiller
It might be caused by the use of keywords as column names - most likely candidate is Date. Try to "escape" all column names: sql = "INSERT into tbl_Record ([Name],[Date],[Toothno],[Procedure],[Amount_Charged],[Amount_Paid],[Balance],[IDrecord]) values (@Name, @Date, @Toothno, @Procedure,...