Hi do anybody knows why I get this error:

Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

/_admin/viewdetails.asp, line 111


Here is part of the code:

' execute the update
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute -------------------------------------------------> Line 111
MM_editCmd.ActiveConnection.Close

Any help would be appreciated.

Thanks.

Hi,

You need to post a bit more of your code - specificly any lines that are used in building the SQL Statement (which is stored in a variable called MM_editQuery).