RS.Rows.count=?

[joey o.]

code:
<%=RS.Rows.count%>
This returns an error. All I want to do is know how many rows in my access db. How do I do this?

[Jerry Grant]

Try <%=RS.RecordCount%>

[joey o.]

This returns -1 for me. I looked through the sight and came up with this loosing answer:

<% RS.movelast%>
<% =RS.RecordCount%><br>
<% RS.movefirst%>

<% =RS.fields.Count-1%><br>

THIS DOESN'T WORK. I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
The rowset does not support fetching backwards
/HelpMeWith/My.asp, line 163

PLEASE HELP!

[monte96]

1) Make sure you are using a cursortype other than adOpenForwardOnly.

2) Make sure you are using a client side cursor location.

3) Do a movelast then a movefirst then check recordcount.

Just FYI- According to Microsoft, recordcount is only 100% accurate when the recordset is based on a table and not a query.