Name

Recordset.MaxRecords Property — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     recordset.MaxRecords = maxrecords
                  

The MaxRecords property indicates the maximum number of records to be returned to a recordset from a query.

Datatype

Long

Description

The MaxRecords property is read- and write-enabled when the Recordset object is open, but read-only when it is closed. A value of 0 (default) indicates that all of the valid records will be returned from a query.

Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.