I used to do alot of development with ado and mssql 6.5, 7.0, and 2000. One of the things that will effect the recordcount is the cursortype and the amount of records returned by the query. I found in all of my mucking with it, that the only easy way to get a total record count from a table is with a sql statement. I.E. Select count(*) form tablename. I know this seems like it will take forever to return but it seem to return quickly enough. I do know that the recordcount property only will return how many records you returned via your query. It does not care how many records are in the table. hope any of this helps.