Click to See Complete Forum and Search --> : Inserting password column into the Table
s_allamneni
02-21-2003, 12:32 AM
I'm trying to INSERT the customer information record into Access table after the customer registers, i can add all the fileds to database table except password column. password is encrypted in my form. Can someone help me how to decrypt the password and insert into text field of the database. BTW i'm using ASP to execute SQL statement.
Thanks
Nicodemas
02-21-2003, 01:24 AM
I think I remember hearing that the word "password" is a reserved word in Access, so you have to enclose the word "password" in braces in your SQL statement:
For Example:
strSQL = "INSERT INTO tblUSER Username,[Password] VALUES('" & Request.Form("txtuser") & "','" & Request.Form("txtpassword") & "')
Hope this solves your problem.. I once made this mistake and it cost me a day of work.