Asp操作Acess查询不到记录问题

[喝口水]

<%
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.RecordSet")
conn.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& server.MapPath("data.mdb") &";"
conn.open
sqlstr="select * from student"
rs.open sqlstr,conn
if rs.recordcount>0 then
response.write ("存在记录")
else
response.Write("记录数为空")
set rs=nothing
set conn=nothing
end if
%>
以上代码我看不出有啥问题，为啥一直显示记录数为空呢，
data.mdb数据库student表中肯定有记录的
并且data.mdb路径也不会错的，可为啥一直查询不到记录呢

[ACMAIN_CHM]

recordset.recordcount 属性 对forwardonly方法的 recordset是无效的，总是返回<=0

可以利用 if rs.eof then 空

<%
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.RecordSet")
conn.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& server.MapPath("data.mdb") &";"
conn.open 
sqlstr="select * from student"
rs.open sqlstr,conn

if rs.eof then		'Changed by ACMAIN
	response.write ("存在记录")
else
	response.Write("记录数为空")
end if

do while not rs.eof		'show the records
	response.Write rs.fields(0).value
	rs.movenext
loop

set rs=nothing
set conn=nothing
%>

QQ群 48866293 / 12035577 / 7440532 / 13666209
ACCESS专业论坛
http://www.accessbbs.cn/bbs/index.php .
http://www.office-cn.net/vvb/ .
http://www.accessoft.com/bbs/index.asp .
http://www.access-programmers.co.uk/forums .
.
http://www.office-cn.net/home/space.php?uid=141646 .

[look4sword]

楼上正解，一般都用rs.eof来判断。

[sy_binbin]

sqlstr="select * from student"
rs.open sqlstr,conn,1,1
if not(rs.bof and rs.eof) then
response.write ("存在记录")
else
response.Write("记录数为空")
set rs=nothing
set conn=nothing
end if
%>

[喝口水]

<%
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.RecordSet")
conn.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& server.MapPath("data.mdb") &";"
conn.open
sqlstr="select * from student"
rs.open sqlstr,conn,1,3 //加上这个就好了
if rs.recordcount>0 then
response.write ("存在记录")
else
response.Write("记录数为空")
set rs=nothing
set conn=nothing
end if
%>
自己做好了，谢谢各位
回２楼，一般都用eof判断，感觉此方法不妥当，也不安全，如果用eof的话应bof一块使用