MaxRecords Property (ADO)

Microsoft ActiveX Data Objects (ADO)

ADO 2.5 API Reference

MaxRecords Property

Indicates the maximum number of records to return to a Recordset from a query.

Settings and Return Values

Sets or returns a Long value that indicates the maximum number of records to return. Default is zero (no limit).

Remarks

Use the MaxRecords property to limit the number of records that 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.

See Also

Visual Basic Example | Visual C++ Example | Visual J++ Example

Applies To: Recordset Object

© 1998-2003 Microsoft Corporation. All rights reserved.