Getting the RecordCount

How can I get the record count value in an ADODB.Recordset object? It always returns a -1. Thanks.

You have to change the CursorLocation property to adUseClient before you open your recordset.

Have you tried using anything similar to this?

Code:

---

Dim cnn As Connection
Dim rs As Recordset
Dim rc As String


  .....
  .......

    Set rs = New Recordset
    rs.Open
    rc = rs.RecordCount
    Label1.Caption = rc
    rs.Close

---

I've noticed that setting the ADO Recordset cursor to Static will return a record count (which makes sense, if the recordset changes, how can you count it?)

Code:

---

adoRset.Open "table", adoConn, adOpenStatic, adLockReadOnly

---

Use either adOpenKeyset or adOpenStatic as the CursorType for server side cursors, or use a client side cursor (since client side cursors use only adOpenStatic for CursorTypes).

I'm opening the recordset with this statement:

Rst.Open "SELECT * FROM <TABLE>", Conn, adOpenDynamic, adLockOptimistic, adCmdText

Have tried Serge's tip and it worked! Thanks Serge and to the others who gave their tips....