Throttle Results With the ADO MaxRecords Property

The following example shows how you can use the MaxRecords Property in ADO to throttle the number of rows returned from your query.

SET rstTitles = New ADODB.Recordset
rstTitles.MaxRecords = 10
strSQLTitles = "SELECT Tagname FROM ihTags"
rstTitles.Open strSQLTitles, strCnxn, adOpenStatic, adLockReadOnly, adCmdText