Hi all,

I am currently perplexed by an error I receive when trying to change the Username or Password values in an Access database. I believe the Password field is somehow the source of my grief because when I set the Update server behavior to "ignore" the password form field I'm able to update the Username. However, when NOT set to "ignore" it I get this error when attempting to update a Username or Password:

<font color=red>Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

/change.asp, line 145</font id=red>

(Line 145 is: MM_editCmd.Execute)

Both the form fields txtUsername and txtPassword are set to update text in the columns labeled Username and Password in the Access Database. I also have the type "password" checked instead of "text" in the property inspector to have the password appear as *** in the form field area.

I checked Access reserved names and don't believe I have a violation there as it only listed NewPassword as reserved and not Password.
If anyone can help me with understanding and correcting this error I'd appreciate it so much.

Many Thanks,

Jean-Marie

I thought I would still post the fix even though this was posted 4 years ago.

Put the reserved word, in my case Password (reserved in JET), in square brackets as below

MM_columnsStr = "Title|',none,''|Firstname|',none,''|Lastname|',none,''|CompanyName|',none,''|Email|',none,''|type|',none,''|MPosition|',none,''|ApprovalNo|',none,''|<b>[Password]</b>|',none,''|TelNo|',none,''|FaxNo|',none,''|PostCode|',none,''|status|',none,''"

It worked ok for me after that.

Here's a good link to a list of reserved words for most database engines: sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html

Edited by - ukbrightonbloke on 26 Sep 2006 12:24:04

Persistance always pays.....

(nice to post back after this time by the way)

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]