ASP/MS Access paging through large recordset

[Scotter]

I have a 7000 record set in MS Access on a fast server.
Broadband connection.
Takes quite a bit of time to pull the recordset down to a browser.
Makes sense.
So... I set up paging and it still seems like it is reading the entire
recordset just to display page 1 or page 2 or whatever.
I've tried turning buffering on/off.
I've tried changing the CursorType and CursorLocation.
Am I spinning my wheels?
Please help.

 

[Bob Barrows [MVP]]

I have a 7000 record set in MS Access on a fast server.
Broadband connection.
Takes quite a bit of time to pull the recordset down to a browser.
Makes sense.
So... I set up paging and it still seems like it is reading the entire
recordset just to display page 1 or page 2 or whatever.
I've tried turning buffering on/off.
I've tried changing the CursorType and CursorLocation.
Am I spinning my wheels?
Please help.

We've pointed you at aspfaq before. Have you checked there? I'm pretty sure
there's an article there about recordset paging. I also think Ken Shaeffer
has one on his site www.adopenstatic.com

Bob Barrows

 

[Aaron [SQL Server MVP]]

So... I set up paging and it still seems like it is reading the entire

recordset just to display page 1 or page 2 or whatever.
I've tried turning buffering on/off.
I've tried changing the CursorType and CursorLocation.

http://www.aspfaq.com/2120