change password - error

[dsjk]

Hi

I have created a login with username and password.
When the user is logged in, he can see his details (name, username, password)
and change these details.
But when I want to save changes this error is shown:

Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

/sikker/retmedlem.asp, line 121

and line 121 in retmedlem.asp is:

MM_editCmd.Execute

I found out that it is the password that causes the problem. Because I have created a similar detailpage, but without the password details. And this page is running fine.

Hope you can help.

thank u

dsjk

 

[Cheech]

the pointer to line 121, or the xx.Execute command is a bit of a "red herring" what you should look at is the line that builds your UPDATE statement somewhere in there you have a definition wrong compared to the database definition

Cheech Live long and make your kids suffer..

 

[dsjk]

I can't see any errors.
It is only the password, i can't update, because if i remove the password from the update form, it updates fine, no problem, but when i put the password, back on, to update the error shows again.
If you like, you can see the code here:

http://www.densortejakke.dk/retmedlem.txt

In my access database, i have defined the password as text, and a max size at 50.

dsjk

 

[dsjk]

problem solved.
I can't use "password" as a field, but when i placed [ ] around it, there are no problems.


dsjk