I am seriously stumped here and hope that someone here can help.
I am still banging my head against the wall trying to get a site done. I have created a form with 5 inpit fields, name, address, etc.
One of these fields is a memo format, the rest text.
I get the error below every time I try it out.
I have gone so far as create another site, and have all of one asp page and the access database.
I still cannot get it to work.
I get the error type in IE listed below and the code on line 115 is listed below it. The line it references (115) Any ideas?
P.S., I have changed the permissions so that should not be it.




Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/03B/input.asp, line 115



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 115)

MM_editCmd.ActiveConnection.Close

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

Can you show us the insert statement? or more code?