Applies To Select query, SQL-Specific query.
Description
You can use the MaxRecords property to determine or specify the maximum number of records that will be returned by a query that returns data from an ODBC database.
Setting
The MaxRecords property setting is a Long Integer value representing the number of records that will be returned.
You can set this property by using the query's property sheet or Visual Basic. When you set this property in Visual Basic you use the DAO MaxRecords property. Remarks Records are returned in the order specified by the query's ORDER BY clause. You can use the MaxRecords property in situations where limited system resources might prohibit a large number of returned records.See Also MaxRecords property ("DAO Language Reference").