I'm making a private messaging system and I'm getting an error on the send page (using Insert Record behavior). I'm using URL parameters to preselect reciever(s). But when submitting the page I get this error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax in INSERT INTO-sentence
/2NO/insert_private.asp, line 115

(this text is originally in Norwegian but I translated it to english. Some wrong translations maybe).

Line 115 reads:

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 remember getting this error earlier in my history making ASP-sites, but whatever I do, I don't get it right...

I'm sure someone knows what's wrong
Using ASP VB on MS IIS 5.1
(also tested the same on ASP JS)

I don't know about you, but I got the same kind of error from SQL ("you have a syntax error nreal INSERT (blabla) on line 1" and curoiusly enough, I had used bad naems for my columns, like "load", and "keys". After changing those "reserved words" everything worked alright.

Less is more1

I don't know about you, but I got the same kind of error from SQL ("you have a syntax error nreal INSERT (blabla) on line 1" and curoiusly enough, I had used bad naems for my columns, like "load", and "keys". After changing those "reserved words" everything worked alright.

Less is more1

God bless you Demonike. That was the clue I neeeded. Those damned reserved words!

.:. DWMX .:. MS IIS 5.1 .:. WinXP .:. MS Acsess XP