1)Is there any way to force restriction on a recordset object so that a query returns 'x' number of records only.  Say if 10 records exist in a particular category and I want
only 3 or 4 or 7 how to enforce the restriction in a query.  It seems that Top clause will not be efficient here as it will return the number of records existing according to sorting criteria. But I will not use orderby clause here. Is there anything better  than top clause? What is a work around to use Distinct keyword with a field, with Top clause as it gives syntax error.
Is there any way out here?

2)Does Microsoft.jet.oledb4.0 provider support multiple recordset management(i.e multiple queries separated by ;)

The SELECT TOP is the only way for MSSQL I believe, even with Access, or mySQL there's not really any other way...

Of course I think the reason is, there's no way for the SQL server to know WHAT you want to return the top of, until you specify the conditions, and/or orderby.



Jet may have supported it... but I wouldn't do it offhand though... depending on how, it would leave you open to malicious uses -- it may have been disabled... or still might work, try it and see -- although if you're executing different commands, just use the connection object's .Execute command, or other way.

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

Thanx for your reply.

My jet does not support multiple query.(its 4.0).  I use recordset.open "query"