Last post Jan 19, 2010 01:43 PM by krishnada25
Jan 14, 2010 04:33 PM|krishnada25|LINK
Hi All ,
I created a database with all text fields. I am using asp to enter the data into access
INSERT INTO Form (fname, lname, sID, fl, email, job, employer, Position, grade, degreename, degreetime, degreePlace ) VALUES ('chris','v','12323','cv','firstname.lastname@example.org','Yes','Uc','Developer','Yes','test','2010','Uc')
Above is the sql I am trying to insert [ Response.write(sSql)]
But it is failing and I am not able to insert the data in the table.
I am getting Microsoft JET Database Engine error '80040e14' Syntax error in INSERT INTO statement Error.
Jan 14, 2010 04:45 PM|Mikesdotnetting|LINK
Position is a reserved word in Jet SQL:
Jan 19, 2010 01:43 PM|krishnada25|LINK
I resolved it by adding  to all fields in the insert query.
ex: insert into tabledummy([name],[no]) values('a','1')