Forums
This topic is locked
reserved words in ASP SQL
Posted 11 Dec 2003 22:49:04
1
has voted
11 Dec 2003 22:49:04 Claudio Huyskens posted:
<font color=red>Microsoft JET Database Engine error '80040e14' Syntax error in INSERT INTO statement.
</font id=red>
this is the error message I get again and again when inserting into or updating one of the tables of my DB.
I researched at Microsoft. There was one support note saying that error 80040e14 means you used a reserved word for the table or the columns. Now I changed the name of the table, most of the column names but the error message still comes up. It has to do with the table as all pages updating other tables work perfectly well.
I would appreciate your help.
By the way, the name of the table is: PAnmeldung, the columns are labeled UID, ID, Benutzer, Password, Bestaetigt
Replies
Replied 13 Dec 2003 17:05:21
13 Dec 2003 17:05:21 C A Vijayan replied:
Password is a reserved keyword; Change that, then it should work ...