Redirect to user info edit page
To redirect to the user info edit page use the following code in Login page: After successful login event.
Note: Change the values listed in red to match your specific needs.
set data=dal.Table("UserTableName").Query("UserNameField='"& username & _
"' and PasswordField='" & password & "'","")
asp_ header "Location: tablename_edit.asp?editid1=" & data("IDField")
response.end
For more information about using Data Access Layer (DAL), see Data Access Layer.