Case sensitive search in Access Database

ultramods wrote: You could only allow users to have lower case usernames. For example username="ULTRAMODS" RESPONSE.WRITE(LCase(username)) would change username to ultramods

sorry to bother you again but where would this part go?

I was gonna give it a try cos the otha thing neva worked   it was sayin sumthin about it cant carry out the operation cos it wasn't valid .  So if i just change the log in so that they're all lowercase now then at least it should work from now on and ill deal with the ppl who have the same usernames some other way.

Thanks! 

Well this is what I had for the full verify page:

____________________________________________________

<%
 'Save the entered username and password
 username = Request.Form("username") 
 password1 = Request.Form("password1")
 
 if username = "" then Response.redirect("empty.asp")
 if password1 = "" then Response.Redirect("empty.asp")
 
 'Build connection with database
 set conn = server.CreateObject ("ADODB.Connection")  
 conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\home\Default\****************************"
 set rs = server.CreateObject ("ADODB.Recordset")  
 rs.Open "SELECT * FROM admin where username='"& username &"' AND password=' " & password " ' ",
 
 
 IF not rs.EOF  THEN
 Session("name") = rs("fullname")
 

 else
  Resonse.Redirect("login_id.asp")
  
 end if

  rs.Close
  conn.Close
  set rs=nothing
  set conn=nothing

%>

_________________________________________________

And this is the error message I got:

ADODB.Recordset error '800a0e7d'

The connection cannot be used to perform this operation. It is either closed or invalid in this context.

/members/verify.asp, line 13

Line 13 is this one:

rs.Open "SELECT * FROM admin where username='"& username &"' AND password1=' " & password1 &" ' "

Any idea what went wrong?

Thanks so much for helping me!!