ASP/MS Access paging through large recordset

S

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.
 
B

Bob Barrows [MVP]

Scotter said:
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.
Click to expand...

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
 
Top