Forums

This topic is locked

Insert Record Error

Posted 14 Feb 2002 15:19:12
1
has voted
14 Feb 2002 15:19:12 Jennifer Shark posted:
Hi,

I have built an insert record page in U/D which comes up with the following error when I run it:
<i>
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/announcements/internal.asp, line 90
</i>

The code @ line 90 is as follows:
<i>MM_editCmd.Execute</i>

The whole statement is as follows:
<i> 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
MM_editCmd.ActiveConnection.Close</i>

This is ultradev's own code, am I totally blind that I don't see the error? Can someone help?

Thanks!

Reply to this topic