[AccessD] ado recordcount

What kind of recordset are you opening.  I never have a problem with Keyset.
Then again, I rarely care how many records there are, since I am usually
just looping until I reach EOF.  When I'm done, I have a collection I can
just get the count of.

Also, MoveLast may be all you need, moving First again may goof the count,
not sure.

Drew 

-----Original Message-----
From: John Colby
To: AccessD
Sent: 10/18/03 10:38 PM
Subject: [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