[asp]dsn to access mdb
<%
set dbconnection=server.createobject("adodb.connection")
dbconnection.open "kpdb"
set rs=server.createobject("adodb.recordset")
rs.open "schoolnew",dbconnection
%>
set dbconnection=server.createobject("adodb.connection")
dbconnection.open "kpdb"
set rs=server.createobject("adodb.recordset")
rs.open "schoolnew",dbconnection
%>
<%
rs.movefirst
while not rs.eof
response.write rs("title")
rs.movenext
wend
rs.close dbconnection.close
%>
rs.movefirst
while not rs.eof
response.write rs("title")
rs.movenext
wend
rs.close dbconnection.close
%>