[AccessD] ado recordcount

Have you tried setting the cursor location before opening the actual recordset, something like below
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open("SELECT * FROM whatever")
msgbox rs.recordcount

I think the above should work, if not please let me know.
Paul Hartland



Message date : Oct 19 2003, 08:58 AM 
>From : Erwin Craps 
To : Access Developers discussion and problem solving 
Copy to : 
Subject : RE: [AccessD] ado recordcount 
Some cursortypes do not support rowcount... 

-----Oorspronkelijk bericht----- 
Van: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] Namens John Colby 
Verzonden: zondag 19 oktober 2003 5:38 
Aan: AccessD 
Onderwerp: [AccessD] ado recordcount 


I am opening a recordset (raw table) that contains records. 
Move last, move first. 
EOF and BOF are both false. 

Recordcount = -1 

What gives? How do I tell how many records in the recordset? 

John W. Colby 
www.colbyconsulting.com 

_______________________________________________ 
AccessD mailing list 
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 
_______________________________________________ 
AccessD mailing list 
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com