Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: Access 2013 | Access 2016
Specifies the maximum number of records that will be returned by:
A query that returns data from an ODBC database to a Microsoft Access database.
A view that returns data from a SQL database to an Access project (.adp).
Setting
The MaxRecords property setting is a Long Integer value representing the number of records that will be returned.
In a Microsoft Access database, you can set this property by using the query's property sheet or Visual Basic.
Remarks
When you set this property in Visual Basic, you use the ADO MaxRecords property.
Records are returned in the order specified by the query's ORDER BY clause.
Use the MaxRecords property in situations where limited system resources might prohibit a large number of returned records.
See also
- Access for developers forum
- Access help on support.office.com
- Access help on answers.microsoft.com
- Access forums on UtterAccess
- Access developer and VBA programming help center (FMS)
- Access posts on StackOverflow
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.