Login from a Database

<i><b>Originally posted by : Charles (cjanco@mindspring.com)</b></i><br />I need to provide a user name and login for a site and have the info passed to each page with an include file. I found an example and it works perfectly. I just need to change it so the password and username is taken from my Access database. I think all I need to change is this function below:<br /><br />Function ValidateLogin( sId, sPwd ) <br />ValidateLogin = False<br />If sId = "admin" AND sPwd="adminpass" Then<br />ValidateLogin = True<br />End If<br />End Function<br /><br />Thanks in advance for your help!

<i><b>Originally posted by : steve</b></i><br />all you really have to change is do a select * from tbllogin and validate the recordset. if request("loginid") = rs("loginid") then let them view the page else redirect page to the login page. is there more to the function that you posted?<br /><br /><br />------------<br />Charles at 3/26/2000 2:17:38 PM<br /><br />I need to provide a user name and login for a site and have the info passed to each page with an include file. I found an example and it works perfectly. I just need to change it so the password and username is taken from my Access database. I think all I need to change is this function below:<br /><br />Function ValidateLogin( sId, sPwd ) <br />ValidateLogin = False<br />If sId = "admin" AND sPwd="adminpass" Then<br />ValidateLogin = True<br />End If<br />End Function<br /><br />Thanks in advance for your help!