DO you have anything (Field) in the Table to indicate the date, like a time stamp field or date added field. If so you can make the RecordSource of the ADODC to something like...

SELECT * FROM T_OBJECT WHERE TimeStamp > '2000/11/08'

If not then you can use the SQL TOP keyword...

SELECT TOP 10 * FROM T_OBJECT

Or you can return a Percentage of the records...

SELECT TOP 10 PERCENT * FROM T_OBJECT