| news@blueyonder.co.uk 2004-08-06, 12:15 pm |
| 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
|