Restricting the number of records in ADODB recordset is possible by using property 'MaxRecords', but it works only with SQL Server database and doesn't work with MS-Access database. Can anyone suggest a way to make it working. Please be sure that combination is ADODB, MS-Access database and linked with MS-Access DSN. Awaiting solution

Shreekant Bilurkar