hi i'm writing asp to get data from a database 

which works fine and the form gathers the information from the 

database.

i have an update.asp as well but when i press the send button

 

i get the message 



Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 





[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. 





/ccmsystems/pages/forms/updatetest.asp, line 32 



line 32 on the updatetest.asp =   Conn.Execute(update_sql);



 



any help would be much appreciated 



thanks 



karl

I would suggest that the SQL statement itself is invalid. 



Prior to line 32, enter the line...



Response.Write update_sql & "<BR>"



and check to see that the SQL statement is what you expected.  Run the SQL 

statement directly in Access or SQL Server to see if it produces the 

result you expected. 



Or, include a copy here and I'll see if I can see anything wrong with it. 



Regards



Paul