[AccessD] Paging Recordsets

Martin,
What front-end are you pulling the recordsets into (Web, Access, VB6) ?
I know you can use the commands YourRecordset.PageSize=100, YourRecordset.CacheSize, YourRecordset.AbsolutePage=YourPageNumber
Not sure how they actually work, haven't used them in working examples before....but if your returning the results to a Web page this might be of interest to you http://www.brettb.com/EasyADORecordSetPaging.asp
Paul Hartland





Message date : May 25 2004, 09:59 PM
>From : "Martin Reid" 
To : "Access Developers discussion and problem solving" 
Copy to : 
Subject : [AccessD] Paging Recordsets
Anyone every done any work on paging large recordsets in Access. I want to
look at the possibility of breaking up massive recordsets returned from SQL
Server in page sets of say 100 records. Rather than pull them all at the
start I want the user to be able to select Page 1, Page etc etc then move
freely between pages.

Only 100 records (or less) would be taken of the server at one time.

I cannot use filters at the client end. All records MUST be available?

MArtin

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm