Syntax error in UPDATE statement

<i><b>Originally posted by : Bergis (bergis80@hotmail.com)</b></i><br />Hi there,<br /> I'm really desperate, I've try to fix this myself but I really don't see what is wrong in my statement, I've triple-check many times, tried many things, but still can't see what I am doing wrong, any help would be greatly apreciated.<br /><br />I am doing an update by giving an sql statement to an ADODB.Command object, using his CommandText property like this :<br /><br />objCmd.CommandText = SQLStmt<br />objCmd.Execute<br /><br />here's what SQLStmt looks like when it goes into the CommandText (I've made an response.write just to see the output) : UPDATE membres SET nom_personnage='uuuuuuuuu',dispo='yyyyyyyyyyy',pre sentation='bla',email='bla2',icq='66666',password= 'test',level='66666',classe='amazon' WHERE nom_membre = 'test' <br /><br />And I am Getting this error :<br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. <br /><br />I am not getting this error if I remove the "level" part. If I skip on the level field, everything goes well. But as soon as I add this field, boum!<br /><br />Now all those fields are text or memos. I just don't see what is wrong with the "level" part, it uses the same syntax and all. I'm going crazy over this. If anyone can shed a light over this it would lift my spirit <br />thank you very much,<br />Bergis<br /><br />P.S.: Sorry for my english, it's not my first langage. <br />

<i><b>Originally posted by : Jeremy (footj@yahoo.com)</b></i><br />I got this same error. I fixed it by changing level='66666' to membres.level='66666' or by renaming the level feild to something like level1. <br /><br />Can you help me? I keep getting "Operation must use an updateable query" error. My update query is set up just like yours.<br /><br />Jeremy<br /><br /><br />------------<br />Bergis at 2/1/2001 6:36:20 AM<br /><br />Hi there,<br /> I'm really desperate, I've try to fix this myself but I really don't see what is wrong in my statement, I've triple-check many times, tried many things, but still can't see what I am doing wrong, any help would be greatly apreciated.<br /><br />I am doing an update by giving an sql statement to an ADODB.Command object, using his CommandText property like this :<br /><br />objCmd.CommandText = SQLStmt<br />objCmd.Execute<br /><br />here's what SQLStmt looks like when it goes into the CommandText (I've made an response.write just to see the output) : UPDATE membres SET nom_personnage='uuuuuuuuu',dispo='yyyyyyyyyyy',pre sentation='bla',email='bla2',icq='66666',password= 'test',level='66666',classe='amazon' WHERE nom_membre = 'test' <br /><br />And I am Getting this error :<br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. <br /><br />I am not getting this error if I remove the "level" part. If I skip on the level field, everything goes well. But as soon as I add this field, boum!<br /><br />Now all those fields are text or memos. I just don't see what is wrong with the "level" part, it uses the same syntax and all. I'm going crazy over this. If anyone can shed a light over this it would lift my spirit <br />thank you very much,<br />Bergis<br /><br />P.S.: Sorry for my english, it's not my first langage. <br />