>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???
>
>Regards,
>
>Jason


**Note** It is an ADO recordset that I'm trying to work with. Using the SQL Server 6.5 ODBC driver as a provider.