password is a reserved word in MSAccess (and delete as well). Check these posts:
http://www.aspfriends.com/search/MSG.ASP?msgid=679958 http://www.aspfriends.com/search/MSG.ASP?msgid=637775 Get that function and rewrite your code as follows: sqlstmt = "UPDATE [tbluser]" & _ " SET [UserFirst] = " & SqlText(FName) & _ ", [UserLast] = " & SqlText(LName) & _ ", [Password = " & SqlText(Password) & _ ", [Group] = " & SqlText(Group) & _ ", [Department] = " & SqlText(Depart) & _ ", [Delete] = " & SqlText(Delete) & _ " WHERE [User] = " & SqlText(UserID) David L. Penton, Microsoft MVP JCPenney Technical Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Jon Barnhardt [mailto:jon_barnhardt@;educ8.org] Today is just not my day for SQL statements Any ideas on the following? sqlstmt = "UPDATE tbluser" sqlstmt = sqlstmt & " SET UserFirst='" & FName & "'," sqlstmt = sqlstmt & "UserLast='" & LName & "'," sqlstmt = sqlstmt & "Password='" & Password & "'," sqlstmt = sqlstmt & "Group='" & Group & "'," sqlstmt = sqlstmt & "Department='" & Depart & "'," sqlstmt = sqlstmt & "Delete='" & Delete & "'" sqlstmt = sqlstmt & "WHERE User='" & UserID & "'" gives the error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement Thanks again Jon>> today --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
