Sets or returns the maximum number of records to return from a query against an ODBC data source.

Settings And Return Values

The setting or return value is a Long that represents the number of records to be returned. The default value is 0, indicating no limit on the number of records returned.

Remarks

Once the number of rows specified by MaxRecords is returned to your application in a Recordset, the query processor will stop returning additional records even if more records would qualify for inclusion in the Recordset. This property is useful in situations where limited client resources prohibit management of large numbers of records.

Note The MaxRecords property can only be used with an ODBC data source, connected through either a Microsoft Jet or ODBCDirect workspace.