Try something like below:
default.asp
<form action=login.asp method=post>
Username <input name=username>
Password <input name=password>
</form>
login.asp
<%
Set adoconn = Server.CreateObject("ADODB.Connection")
adoconn.Provider = "Microsoft.Jet.OLEDB.4.0"
adoconn.ConnectionString = "Data Source=C:\mydir\mydb.mdb"
adoconn.Open
query = "select url from users where username = '" & Request("username") & "' and pw = '" & Request("password") & "'"
set rs = adoconn.execute(query)
if not rs.eof
Response.Redirect("url")
end if
rs.close
set rs = nothing
%>
|