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