iis4 doesn't return all records

External Since: Jun 02, 2004 Posts: 2

I wonder if you guys can help...

I have an asp page served from IIS4 on NT4 Server. The page queries an
Access database and should return 2000+ lines and each line has a listbox
that is populated from another table with ten records. When the page is
submitted it only returns 900 records and falls over when populating the
listbox for the umpteenth time. I cannot understand why it works
successfully for 900 records but then fails and gives no errors.

The page works fine with other queries using the same page delivering fewer
records so am I expecting too much?

Many Thanks in Advance

Rob Bee

External Since: Apr 22, 2004 Posts: 390

No,youre not expecting too much. First question I would ask is:

1. Did it ever work before? Or, have you just tried it for the first time?
2. If it worked in the past and suddenly stopped working did you do anything=
in between or was it sudden?

John Cesta

---------------------------------
The CPU Checker - Maximize Server Uptime
LogFileManager - The only IIS Logfile Management Tool
DomainReportIt PRO - Helps Convert IIS Installs
<a style='text-decoration: underline;' href="http://www.serverautomationtools.com" target="_blank">http://www.serverautomationtools.com</a>

On Wed, 2 Jun 2004 15:01:40 -0400, buzz wrote:
> I wonder if you guys can help...
>
> I have an asp page served from IIS4 on NT4 Server. The page queries
> an
> Access database and should return 2000+ lines and each line has a
> listbox
> that is populated from another table with ten records. When the
> page is
> submitted it only returns 900 records and falls over when
> populating the
> listbox for the umpteenth time. I cannot understand why it works
> successfully for 900 records but then fails and gives no errors.
>
> The page works fine with other queries using the same page
> delivering fewer
> records so am I expecting too much?
>
> Many Thanks in Advance
>
>
> Rob Bee