The ADO Recordset's .maxRecords property requires that the underlying ODBC Driver or OLEDB Provider provide support for limiting the number of records returned. Neither the ODBC Driver for Jet, not the OLEDB Provider for Jet exposes this functionality. For more information (and a possible solution) see Q186267. Back to FAQ listing.