Update Error

Hi all,

At present I have a table with two fields which updates records in a
database. Using the login behaviour from the server behaviour menu.

Only problem is when I submit the form, I constantly get the error

"Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement"
/arem_concept_060804/Admin.asp, line 111


106 If (Not MM_abortEdit) Then
107 ' execute the update
108 Set MM_editCmd = Server.CreateObject("ADODB.Command")
109 MM_editCmd.ActiveConnection = MM_editConnection
110 MM_editCmd.CommandText = MM_editQuery
111 MM_editCmd.Execute
112 MM_editCmd.ActiveConnection.Close
113
114 If (MM_editRedirectUrl <> "") Then
115 Response.Redirect(MM_editRedirectUrl)
116 End If
117 End If

I can view and add new records, but not update them. The database in stored
within the root folder, and has the correct permissions I.e. "Internet
guest account" full access. so I'm currently at a lost. all help will be
appreciated.

OS Windows XP
Local IIS

Thanks in advance for you help.

Paul

See

http://www.google.com/search?q=80040e14

Note that your error is similar to the INSERT INTO error too. It's probably
down to the dodgy fieldnames you are using.


--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004