Case sensitive search in Access Database

Hiya!

I have a big problem.  On my site I have a member area ppl can join and log in to but recently I found out that if you join with say the name 'Michelle' and there is already a 'michelle' in the database it would allow that but when it is verifying a log in its not case sensitive anymore and so it just looks for the first michelle.

How do I change it so that its not case sensitive?  So that it woudln't allow a michelle and a Michelle?

Here is the part of the script that creates a new user:

________________________________________________________

  'Build connection
 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")
 'Open all records
 rs.Open "SELECT * FROM admin", conn, 3, 3
   
 'Check if username doesn't already exist
 do while not rs.EOF
  if rs("username")=username then
   set rs=nothing
   set conn=nothing
   Response.Redirect("taken.asp")
  end if
  rs.MoveNext
 loop

_________________________________________________________

Please help me! 
Thanks so much for reading

Loadsa love,
Vicky xxx

thanks for the fast reply!  but I guess that wouldn't really work since I already have hundreds of members in the database

How could I change it so that when it was verfiying it remained case sensitive?

Here is the verifying part of the script:

__________________________________________________________

'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 &"'", conn, 1

__________________________________________________________

Thanks so much!

OK if you want to do it the way you first said you could try using.

'Build connection
 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")
 'Open all records
 rs.Open "SELECT * FROM admin where username= " & username & " ' " ", conn, 3, 3 

   
IF rs.EOF THEN                                                             

        RESPONSE.WRITE("yes you can have that username")

ELSE

          RESPONSE.WRITE("sorry username taken")

END IF

If Michelle is registered it wont allow michelle to be registered.

Ok, I tried both methods and neither worked...I keep getting error messages.  I must be doing something wrong   for the first method when logging in and you search for the username and password, wot would the next line be after

"SELECT * FROM admin where username='"& username &"' AND password1=' " & password1 " ' ",

just now i have:

If not rs("username") = username AND rs("password1") = password1 then
  rs.close
  conn.close
  set rs=nothing
  set conn=nothing
  Response.Redirect("login_id.asp")
 end if

can u see where I have gone wrong?

Thanks for your help I really appreciate it!