password database

<i><b>Originally posted by : Mark (mkirk8390@aol.com)</b></i><br />I can't get the page to recognize the database.<br />I have no idea what I'm doing wrong. I'm sure<br />it's something simple. Will someone please help.<br />The line of code is:<br /><< strconn = "DBQ=" & Server.Mappath("db/password.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};" <br />set conn = server.createobject("ADODB.Connection")<br />set rs = server.createobject("ADODB.Recordset")<br />conn.open strconn<br />rs.open "SELECT tblMemberInfo.MemberID, tblMemberInfo.ZoneName, tblPassword.Password " & _<br /> "FROM tblMemberInfo INNER JOIN tblPassword ON tblMemberInfo.MemberID = tblPassword.MemberID " & _<br /> "WHERE (((tblMemberInfo.ZoneName)='" & request("ZoneName") & "'))", conn, 2, 2 >><br /><br />The url is: www.adventurecrazy.org/password/login.asp<br /><br />Please e-mail me if you have any suggestions. Thanks.<br /><br />Mark<br />

<i><b>Originally posted by : Luciano (luciano@asas.net)</b></i><br />HI Mark,<br /><br />But when you use "server.mappath()"<br />be sure that doesn't exist another file with the same name in another folder.<br /><br />Luciano<br /><br /><br /><br /><br />