It works before...but why this?
Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/Auction/register.asp, line 117

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command"
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute <---------------------------------------This is line 117:

MM_editCmd.ActiveConnection.Close

If (MM_editRedirectUrl <> "" Then
Response.Redirect(MM_editRedirectUrl)
End If

I had a similar problem, dont know if it will help but to fix my problem i enetred data into every field, for some reason it didnt like a blank field.
May help, good luck
Portfox

If you're using Access, check if every field has 'Allow Zero Lenght' set to Yes.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I had a similar problem, dont know if it will help but to fix my problem i enetred data into every field, for some reason it didnt like a blank field.
May help, good luck
Portfox


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

Edited by - vfarcic on 30 Jan 2002 10:20:28