I keep trying to insert a row into an Access database and keep getting an error that there is an syntax error in my insert into commmand. I have done this many times and even tried inserting one piece of information instead of the whole line and get the same error can someone please look at this and see if I missed something. I must have because it is still not working.
<%
Set objppDbase=Server.CreateObject("ADODB.Connection")
objppDbase.ConnectionTimeout=60
objppDbase.Open "DSN=Pre-Post"
%>
<%
SQLprepost = "insert into Pre_Post(date,datetime,aname,hoff_received,hoff_received_undoc," & _
"calls_taken,total_calls_taken,num_analyst_shift,rona,tckts_opened,call_tracking," & _
"call_tracking_l1,call_tracking_l2,call_tracking_ref,call_esc,call_esc_pe," & _
"call_esc_crit_disp,call_esc_reef_disp,call_esc_int,call_esc_ops,tckts_closed," & _
"warm_assist,tckts_solutions,tckts_sol_undoc,tckts_owned,tckts_still_open,tckts_passed," & _
"solutions_created,check_email,check_solution,check_summary,check_name)" & _
"values('" & today & "','" & datetime & "','" & name & "','" & hoff & "','" & hoffu & _
"','" & calls & "','" & tcalls & "','" & numba & "','" & rona & "','" & topen & _
"','" & cttopen & "','" & cttopen1 & "','" & cttopen2 & "','" & cttopenr & "','" & _
escalls & "','" & escpe & "','" & esccd & "','" & escrd & "','" & escint & "','" & _
escops & "','" & closed & "','" & wassist & "','" & qtsol & "','" & qtsolu & "','" & _
ownt & "','" & open & "','" & passed & "','" & sol & "','" & c_ema & "','" & c_sol & _
"','" & c_sum & "','" & c_name & "')"
objppDbase.Execute(SQLprepost)
%>