Restricting No of records in ADO recordset from MS-Access database

[Shreekant B]

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

[Clunietp]

interesting.....I'm very surprised that the Jet driver doesn't support this!

http://support.microsoft.com/support/kb/articles/Q186/2/67.ASP?LN=EN-US&SD=gn&FR=0

[Zeee]

Have u tried using SELECT TOP [no of records] statement?

Example:

rst.open "SELECT TOP 10 * FROM MyTable WHERE ID = 3",conn,adOpenDynamic,......

effectively returns 10 records basing on the criteria.