Inserting password column into the Table

This site is best viewed in a modern browser with JavaScript enabled.

Inserting password column into the Table

s_allamneni

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

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.