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
Jason Tryon
Senior Systems Analyst / Technical Lead
eBusiness / iPage