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!