如何连接这样的access数据库

我想在asp网站的页面上连接access数据库中表“NewsClass”里classid为5中的新闻，限制显示前10条，请问该怎么写?
<%
select top 10 * from newsclass where classid=5 order by id desc
oRs.Open sSql,oConn,1,1
If Not oRs.Eof Then
%>
<%=ors("newsclass")%>
<%else%>
暂无信息！
<%end if
ors.close%>
这样写为什么不行？

即然要显示十条..当然要循环啦...
<%
select top 10 * from newsclass where classid=5 order by id desc
oRs.Open sSql,oConn,1,1
If Not oRs.Eof Then
while not oRs.eof
%>
<%=ors("newsclass")%>
<%oRs.next
wend
else%>
暂无信息！
<%end if
ors.close%>

set rs=server.CreateObject("adodb.recordset")
sql="select top 10 * from newsclass where classid=5 order by id desc"
rs.open sql,conn,1,1
if rs.eof then
response.write("啥都木有哇……")
else
response("<div>"&rs("newsclass")&"</div>")
end if
rs.close
set rs=nothing

select * top 10 from NewsClass where classid = 5

一楼的说的对着呢
String rs="select * top 10 from NewsClass where classid = 5 ";
就这个

Select top 10 * from newsclass where classid=5 order by id desc
set rs=oconn.execute(sql)
if not rs.eof then