I've been getting an error message when loading a page that retrieves too
much information. The solution that has been advised was to either limit the
number of records to display or to change the 4MB buffer limit in
metabase.xml.

I've tried increasing the limit to about 10MB as a starting point. This
causes the server to ask the user for a username, password and, domain.

I tried turning off buffering prior to writing any Response code by setting:

Response.Write = False

and I'm now getting another error msg:

Response object, ASP 0157 (0x80004005)
Buffering cannot be turned off once it is already turned on.

I don't know what I'm doing wrong in the code, but it uses file Includes.
Here is a sample of the code that's not working after turning off the buffer:

<%
Response.Buffer = False

CALL SpecificPageHeader("Audit History")

selected = Request.Form ("selectTable")

CALL GenericTableHeader ("Search Criteria:")
CALL NavigationHeader (selected)

if selected = "projects" or selected = "" then
CALL GenericTableHeader ("Search Results: Projects")
CALL ProjectHeadings()
CALL PopulateDemands ()
CALL GenericTableFooter ()
Else
CALL GenericTableHeader ("Search Results: Users")
CALL ResourceHeadings()
CALL PopulateResources ()
CALL GenericTableFooter ()
End if

CALL PageFooter()

Response.Buffer = True

%>


Regards,
Eric