Change this:

: Set MM_editCmd = Server.CreateObject("ADODB.Command")
: MM_editCmd.ActiveConnection = MM_editConnection
: MM_editCmd.CommandText = MM_editQuery
: MM_editCmd.Execute
: MM_editCmd.ActiveConnection.Close

To

Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
Response.Write(MM_editQuery)
MM_editCmd.ActiveConnection.Close
Response.End

and then look at what is output to the screen. Also look at this page:
www.adopenstatic.com/faq/80040E14.asp

Cheers
Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Ameer" <ameer418@h...>
Subject: [access_asp] help me


: Hi,
: Please help me if you can as everything I have tried has failed and this
: is the idea I got, ?to ask!?
: I can view the database no problem but can't write/update it.
: I always get the following error:
:
: ?Error Type:
: Microsoft JET Database Engine (0x80040E14)
: Syntax error in INSERT INTO statement.
: /insert.asp, line 90?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~