Hi
Though this is not an ASP section, still we can try to help you out, for your help, you can copy and past the below code in an asp page, I created this page years ago as a login for my application. Just change your access db path and the query to fetch username/password. (marked in red).
----------------------------------------------------------------------
<%
dim username, password
username=TRIM(Request("username"))
password=TRIM(Request("password"))
Dim Con, sql, rec
set Con = Server.CreateObject("ADODB.Connection")
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")
'Select the record matching the username.
sql = "SELECT * FROM tblusers WHERE UCase(username)=' "& UCase(username) & "' AND UCase(password)=' " & UCase(password) & " ' "
set rec=Con.execute(sql)
'If no match found, EOF is not true.
if NOT rec.EOF then
Response.Redirect("somepage.asp") 'Change to page redirect to after login
else
blankError="Invalid username." 'EOF is true, no match found.
end if
%>
<html>
<head>
<title>Login</title>
</head>
<body>
<form name="productForm" method="post" ID="Form1">
<center>
<table border="1" ID="Table1">
<tr>
<td colspan="2">
<%
if blankError<>"" then
Response.Write("<center>"&blankError&"</center>")
end if
%>
</td>
</tr>
<tr>
<td><Strong>Username:</Strong></td>
<td><input type="text" name="username" size="35" ID="Text1"></td>
</tr>
<tr>
<td><Strong>Password</Strong></td>
<td><input type="password" name="password" size="35" ID="Password1"></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="loginButton" value="Login" ID="Submit1">
<input type="reset" name="reset" value="Clear" ID="Reset1"></td>
</tr>
</table>
</center>
</form>
</body>
</html>
----------------------------------------------------------------------
Regards
Mike
Fortune favours the brave, so don't regret on missed oppurtunities.
Help with login page creation
