>I am trying to create a recordset from an SQL 6.5 table. The table holds some 20000 records. (Other tables that I will be after doing similar things with number in the 800000 - 1.5mil records) Initially, I was getting ODBC timeout errors. I set MaxRecords to 100, and I'm getting a very nimble recordset, but it only has 100 records. I need to be able to "Page through" the entire table fetching 100 or so records at a time. Any thoughts???

The MaxRecords property limits the number of records returned from the data source, so you'll always retrieve only 100 records at most unless you change the maxRecords property or your query.

I think the PageSize property is what you're interested in. The ADO documention comes with a good example on how to use it. It enables you to "page" through the set number of records at a time.


Hope that helps,

jody