Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: error message error '80040e14'


Message #1 by karl.hammett@b... on Wed, 12 Sep 2001 16:07:53 +0100
 i get this error message when i press the submit button to update the

database



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 35 



 



this on line 35  Conn.Execute(update_sql);



thanks 



karl
Message #2 by "Jim Losi" <jlosi1@t...> on Wed, 12 Sep 2001 11:32:22 -0400
try



Ser Rs=Conn.Execute(update_sql)



----- Original Message -----

From: <karl.hammett@b...>

To: "Access ASP" <access_asp@p...>

Sent: Wednesday, September 12, 2001 11:07 AM

Subject: [access_asp] error message error '80040e14'





> i get this error message when i press the submit button to update the

> database

>

> 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 35

>

>

>

> this on line 35  Conn.Execute(update_sql);

>

> thanks

>

> karl
Message #3 by "Jim Losi" <jlosi1@t...> on Wed, 12 Sep 2001 11:49:50 -0400
damn. fat fingers..

 what I meant to say was



try

Set Rs=Conn.Execute(update_sql)



----- Original Message -----

From: <karl.hammett@b...>

To: "Access ASP" <access_asp@p...>

Sent: Wednesday, September 12, 2001 11:07 AM

Subject: [access_asp] error message error '80040e14'





> i get this error message when i press the submit button to update the

> database

>

> 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 35

>

>

>

> this on line 35  Conn.Execute(update_sql);

>

> thanks

>

> karl

  Return to Index