[AccessD] Paging Recordsets

Martin Reid mwp.reid at qub.ac.uk
Wed May 26 03:32:37 CDT 2004


Would be from SQL Server to MS Access.

martin


----- Original Message ----- 
From: <paul.hartland at fsmail.net>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, May 26, 2004 9:15 AM
Subject: Re: [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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list