>Hi,
> Thank you for reply. What should I do if i need to fetch the records by batch? for example 10 records per batch without need to requery ?
>
>Thank you

That's the part where I refer to constructing your query so you limit the number of records. The query has to be refreshed for a new set of records whith client side cursors. A client side cursor is what you would use if doing batch updates.

For server-side recordsets, you can use the cachesize property of the recordset object to control how many records ADO fetches from the data source at one time. When the user tries to browse past this number that you specify, the recordset fetches another more records. With this approach you would not need to worry about requerying the table. You would have a client-server scenario with a connection always open to the data source.