Contents Index Topic Contents |
MaxRecords Property - ADO
Indicates the maximum number of records to return to a Recordset from a query.
Applies To
Settings and Return Values
Sets or returns a Long value. Default is zero (no limit).
Remarks
Use the MaxRecords property to limit the number of records the provider returns from the data source. The default setting of this property is zero, which means the provider returns all requested records. The MaxRecords property is read/write when the Recordset is closed and read-only when it is open.
Examples
MaxRecords Property Example (VB)
Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.