Please don't laugh because I'm asking a VB6 question? I have to do some maintenance work. Does anyone know what the maximum number of rows can be returned to a VB6 ADO Recordset? If there is a limit, is there a preferred method for getting around it?
VB6 ADO Recordset Limit
adorecordsetvb6
Best Answer
There is no limit (see link for documentation), but you can provide one if you want. There should be a MaxRecords property that you can set. You have to set it before you open the recordset.