[jugnagpur] how to access limited number of data from database in ms-access

[sagar]

Hi, I want to access first 5 rows from database(ms access),then when i
will click next button then i should access next 5 rows and so on...
It is possible with mysql using limit keyword but while working with
ms-access it gives syntex error. I come to known that there is no
limit keyword in ms-access.
Can any one please tell me the solution.

Thanks in advance

--
---------------------------------------------------------------------------------------------------------------
Java User Group Nagpur
Home Page: http://www.jugnagpur.com
Blog: http://jugnagpur.blogspot.com
Wiki: http://jugnagpur.wikispaces.com/
Project Page: https://jugnagpur.dev.java.net/
---------------------------------------------------------------------------------------------------------------
You received this message because you are subscribed to JUGNagpur group.
To post to this group, send email to jugn...@googlegroups.com
To unsubscribe from this group, send email to
jugnagpur+...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/jugnagpur?hl=en

[Tushar Joshi]

http://www.tutcity.com/view/retrieve-top-n-records-from-a-query.18597.html
This link may help you

with regards
Tushar

==============================================
Tushar Joshi, Nagpur
MCSD_NET C#, SCJP, RHCE, ZCE, PMP
Software Architect @ Infospectrum India Private Limited, JUGNagpur Leader
http://www.info-spectrum.com
http://www.tusharvjoshi.com
http://www.jugnagpur.com

[Chetan Gole]

Hello Sagar,
As you are MySQL user you are using "Limit" keyword.
For Microsoft products we have "TOP" keyword to limit the number of
rows in select statement.
I hope this will solve your problem, Let me know if you still have the
problem.

Regards,
--
Chetan Gole
chetangole.com
+91 996039297