ASP/MS Access paging through large recordset

  • Thread starter Thread starter Scotter
  • Start date Start date
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.
 
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
 
Back
Top