Try this code :
<%
data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("site.mdb"

username = Request("username"

password = Request("password"

try = Request("try"

forgot = Request("forgot"

sendpwtry = Request("sendpwtry"

If sendpwtry = "True" Then
Set rsp = Server.CreateObject("ADODB.Recordset"

rsp.Open "select * from login where ( username = '" & USERNAME & "' )", data_source
If rsp.EOF And rsp.BOF Then
%>
<html>
<head>
<title>
</title>
</head>
<body>
<form action>
<input type="hidden" name="sendpwtry" value="True">
<table>
<tr>
<td><img alt="""" src=""../img/spacer.gif"" height=""10"" width=""1""></td>
</tr>
<tr>
<td colspan=""2""><font face=""Verdana, Arial, Helvetica, sans-serif"" size=""2"">That username does not exist in the database</font></td>
</tr>
<tr>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Username :</font></td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td colspan="2" align="right"><input type="submit" value="Request Password"></td>
</tr>
</table>
</form>
</body>
</html>
<%
rsp.Close
Set rsp = Nothing
Else
%>
<html>
<head>
<title>
</title>
</head>
<body>
<table>
<tr>
<%
name = "Your-Site admin"
senderEmail = "admin@your-site.com"
subject = "You password is..."
recipient = rsp("email"

body = "... Hello " & rsp("username"

& " your password is : ' " & rsp("password"

& " '"
set msg = Server.CreateOBject( "JMail.Message" )
msg.Logging = true
msg.silent = true
msg.From = senderEmail
msg.FromName = name
msg.AddRecipient recipient
msg.body = body
If not msg.Send("mail.your-server.co.uk" ) Then
Response.Write "<td><font face=""Verdana, Arial, Helvetica, sans-serif"" size=""2"">" & msg.log & "</font></td>"
Else
Response.Write "<td><font face=""Verdana, Arial, Helvetica, sans-serif"" size=""2"">Your password has been e-mailed to : " & rsp("email"

& "</font></td>"
End If
rsp.Close
Set rsp = Nothing
%>
</tr>
</table>
</form>
</body>
</html>
<%
End If
Else
If forgot = "True" Then
%>
<html>
<head>
<title>
</title>
</head>
<body>
<form action>
<input type="hidden" name="sendpwtry" value="True">
<table>
<tr>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Username :</font></td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td colspan="2" align="right"><input type="submit" value="Request Password"></td>
</tr>
</table>
</form>
</body>
</html>
<%
Else
If try = "True" Then
If session("access"

= "True" Then
Response.Write ""
Else
Set rsp = Server.CreateObject("ADODB.Recordset"

rsp.Open "select * from login where ( username = '" & USERNAME & "' ) and ( password = '" & PASSWORD & "')", data_source
If rsp.EOF And rsp.BOF Then
rsp.Close
Set rsp = Nothing
eror = "<tr><td><img alt="""" src=""../img/spacer.gif"" height=""10"" width=""1""></td></tr><tr><td colspan=""2""><font face=""Verdana, Arial, Helvetica, sans-serif"" size=""2""><h1>Login Incorrect</h1>Please retype your <strong>username</strong> and <strong>password</strong></font></td></tr>"
Else
pword = rsp("password"

uname = rsp("username"

rsp.Close
Set rsp = Nothing
If pword = password And uname = username Then
session("access"

=("True"

End If
End If
End If
End If
If Not session("access"

= "True" Then
%>
<html>
<head>
<title>
</title>
</head>
<body>
<form action="default.asp" method="post">
<input type="hidden" name="try" value="True">
<table>
<tr>
<td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Enter you login information below.</font></td>
</tr>
<% =eror %>
<tr>
<td><img alt="" src="../img/spacer.gif" height="10" width="1"></td>
</tr>
<tr>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Username :</font></td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Password :</font></td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><a href="default.asp?forgot=True">Forgot password ?</a></font></td>
</tr>
<tr>
<td colspan="2" align="right"><input type="submit" value="Login"></td>
</tr>
</table>
</form>
</body>
</html>
<%
Else
%>
<html>
<head>
<title>
</title>
</head>
<body>
<table>
<tr>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="2">You are now logged in.</font></td>
</tr>
</table>
</body>
</html>
<%
End If
End If
End If
%> Regards
Big Dave
** If I am wrong I am sorry, but i'm only trying to help!! **