Fetch number of rows given row size

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello All
In my application i have a table of 100 000 records , and i need to fetch
them 10000 each . for example first fetch i need to get 1-10000 records ,
second fetch 10001 -20000 records to the record set.
What can be the MS ACCESS query to get something like this

my client program is a java program..
Here i only require is SQL query..
I am using ado connection to fetch rows

thanks in advance
PRash


.