does anyone know how to alter this connection string so that the database located in the closed dir will be opened.. the closed dir is a secured dir with passwords on it.<BR>as you can see im using an acces database and the connection has to be dns less..<BR><BR>here is the code<BR>thanks in advance<BR><BR>Set conn = Server.CreateObject("ADODB.Connection")<BR>Set Rs = Server.CreateObject("ADODB.Recordset")<BR>conn.ope n "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("closedavop.mdb")<BR>strsql = "SELECT * FROM tblpages WHERE (tblpages.category = " & int(knop) & ") ORDER BY tblpages.level, tblpages.type, tblPages.sort"<BR> strsql, conn, 2, 2<BR><BR>