-
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
-
interesting.....I'm very surprised that the Jet driver doesn't support this!
http://support.microsoft.com/support...-US&SD=gn&FR=0
-
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.
