=================conn.asp========================================
<%
StrSQL="DBQ="+server.mappath("admin/psnews.asp")+";DRIVER={Microsoft Access Driver (*.mdb)};"

set conn=server.createobject("ADODB.CONNECTION")
conn.open StrSQL
%>

=================index.asp========================================


<% Response.Expires = 0 %>

<!--#include file=conn.asp -->
<%
set rs=server.CreateObject("ADODB.RecordSet")
source="select * from BigClass"
rs.Open source,conn,1,1

set rs6=server.CreateObject("ADODB.RecordSet")   '
source6="select * from bulletin order by update2 DESC"
rs6.Open source6,conn,1,1


set rs5=server.CreateObject("ADODB.RecordSet")   
source5="select * from smallclass where bigclassid=36 order by smallclassID DESC"
rs5.Open source5,conn,1,1




 set rs7=server.CreateObject("ADODB.RecordSet")  
 source7="select top 5 * from news where smallclassid=66 order by newsid DESC"
 rs7.Open source7,conn,1,1

 set rs8=server.CreateObject("ADODB.RecordSet")  
 source8="select top 5 * from news where smallclassid=64 order by newsid DESC"
 rs8.Open source8,conn,1,1
%>

.........


£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½