SQL ... NEXT ?

SQL ... NEXT ?

am 25.05.2006 12:05:26 von PW

I need to display some records from an Access database, but there are over
100k records.

Isn't there a way you can use NEXT to display the first 10 records, and then
page through the result set ?

Re: SQL ... NEXT ?

am 25.05.2006 12:53:37 von reb01501

PW wrote:
> I need to display some records from an Access database, but there are
> over 100k records.
>
> Isn't there a way you can use NEXT to display the first 10 records,
> and then page through the result set ?

http://www.aspfaq.com/show.asp?id=2120
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: SQL ... NEXT ?

am 25.05.2006 15:15:03 von PW

"Bob Barrows [MVP]" wrote in message
news:%233425l%23fGHA.3916@TK2MSFTNGP04.phx.gbl...
> PW wrote:
>> I need to display some records from an Access database, but there are
>> over 100k records.
>>
>> Isn't there a way you can use NEXT to display the first 10 records,
>> and then page through the result set ?
>
> http://www.aspfaq.com/show.asp?id=2120
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>


Is this applicable to MS-Access as well ?

Re: SQL ... NEXT ?

am 25.05.2006 16:31:36 von reb01501

PW wrote:
> "Bob Barrows [MVP]" wrote in message
> news:%233425l%23fGHA.3916@TK2MSFTNGP04.phx.gbl...
>> PW wrote:
>>> I need to display some records from an Access database, but there
>>> are over 100k records.
>>>
>>> Isn't there a way you can use NEXT to display the first 10 records,
>>> and then page through the result set ?
>>
>> http://www.aspfaq.com/show.asp?id=2120
>
> Is this applicable to MS-Access as well ?

Yes, the first few techniques described are definitely applicable. The
later ones involving stored procedures are not.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.