Data type mismatch in criteria expression

Hi MorningZ:)

Thanks for your reply to my problem. Yes the language is javascript.

Line #21 is  MM_rsUser.Open();

Your explanation ..made recheck my database table the password has a text field , so I have change this to number field.

Does this mean I need to reload the (.mdb file) to the server? and is there any other changes I need to make due to this error???

Hi there:)

Pls could anyone tell me how to solve this problem. I  have build a website with a login page using ultradev. I have uploaded the site online everything seems fine except for my login page when I type in the password and press the sumbit buttom I get an error message  saying

 Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. .

I have gone back into the code and this is what line 21 code looks like

 MM_rsUser.Open();
  if (!MM_rsUser.EOF || !MM_rsUser.BOF) {
    // username and password match - this is a valid user
    Session("MM_Username") = MM_valUsername;
    if (MM_fldUserAuthorization != "") {
      Session("MM_UserAuthorization") = String(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value);
    } else {
      Session("MM_UserAuthorization") = "";
    }
    if (String(Request.QueryString("accessdenied")) != "undefined" && false) {
      MM_redirectLoginSuccess = Request.QueryString("accessdenied");
    }
    MM_rsUser.Close();
    Response.Redirect(MM_redirectLoginSuccess);
  }
  MM_rsUser.Close();
  Response.Redirect(MM_redirectLoginFailed);
}
%>.

I have tried understanding this problem by searching online for a solutions .....I have found different suggestions on the solution ...but none too specific as I am a bit of a novice regards this area ...I am really confused on how to solve this problem.

Pls I would be grateful if anyone could tell me what to do to solve this problem.