Registration Page

[Microsoft][ODBC Microsoft Access Driver] The field 'UserNames.UserName' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.

I keep getting the above message. When I try to create a registration from the registration page, I enter in a username and password and then hit submit. Thiat error is returned.

Also, I created a username and password in the database manually, and if I try to log on with it I get this message, which I had one time before but can't remember what we did to fix it...

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'UserName = email address

Thanks

please compress your security assist files into a zip archive and attach it to your reply so I can examine the code.

Here are the files you requested.

Thanks.

There are a couple of probelms I can see:
1) The Insert record server behavior on the registration page is only set to store a value in the password column, it is not set to store anything in the username column


I think the cause for this is that you have selected the UserName column as the primary key column.


your table should have the following column at minimum:

UserID - Primary Key/Auto Number
UserName - text
userPassword - Text


when running the wizard, the UserID column should eb selected as the key column.



2) Password should be avoidde3d as a column name, it is a reserved word by the ODBC driver:
321266

Great, I changed my database and was able to register the user. However, I seem to still be experiencing some sort of type problem. Here is the error I recieved. (Is it possible the helper file is not updated? I re-ran the wizard...)

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current operation.

/WA_SecurityAssist/Helper_VB.asp, line 19


Here is the code it is referencing:

Dim idx
For idx=0 To UBound(WA_Auth_Parameter.Item("columns"))
If idx <> 0 Then
WA_Auth_loginSQL = WA_Auth_loginSQL & " AND "
End If
WA_Auth_loginSQL = WA_Auth_loginSQL & WA_Auth_Parameter.Item("columns")(idx) & " = ? "
WA_Auth_login_cmd.Parameters.Append(WA_Auth_login_cmd.CreateParameter("param"&idx, WA_Auth_Parameter.Item("columnTypes")(idx), 1, WA_Auth_Parameter.Item("columnSizes")(idx), WA_Auth_Parameter.Item("columnValues")(idx)))
Next

please send a copy of your currant login page.

Here is the Login Page.

there was no attachment to your last reply.

Trying again.

Thanks.

The Authenticate User server behavior is set to use tyhe UserID column as the username column.


When running the security Assist wizard, you need to make sure the correct columns are chosen.

On the First Step of the wizard, make sure to select the UserID column as the Key Column.


On the third step, you will want to set the Username column as the unique column.


On the fifth step, make sure to select the Correct columns for the username and password column.


On the sixth step, you will need to select the correct columns for the email to address, the user name and the password as well.