i have a page which quite simply inserts a record in a DB. I have never had a problem with this before however this time i get this error----->

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


Browser Type:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)

Page:
POST 55 bytes to /chat/chat.asp

POST Data:
PostedBy=Andrew&PostedTo=Yann&Text=Hello&MM_insert=true

Time:
21 August 2001, 09:49:23

------------------------------->

The code around line 90 is this----->

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

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

------------------
Line 90 is the MM_editCmd.Execute statement.

My DB is ok and i have write permissions to the DB.

Anyone know what this means??????

TIA

Andrew

It seems as soon as i post a thread here i figure it out for myself!!!!

Cant see the wood for the trees. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>