Use a client side cursor with rs.Maxrecords set to your value rather than using server side cursors with pagesizes

If you are querying a SQL 7/2000 database or an Access 2000 database you can specify TOP in your query as an alternative
ex: Select TOP 2 from MyTable where......