<div>
The recordset usually exist only in the scope of the page. &nbsp;Meaning if you load another page, recordset is no more.<br />
<br />
You can however, cache recordset inside a Session variable, tho not advisable for scalability unless you have tons and tons of memory or only have very very few users.<br />
<br />
To cache the recordset just assign it to as session and retrieve the session on another page before doing any operation on the recordset.<br />
<br />
Initialization code:<br />
<br />
Set Session(&quot;theRecordset&quot;) = myRS<br />
<br />
where myRS is a valid recordset<br />
<br />
then do:<br />
<br />
Set myRS = Session(&quot;theRecordset&quot;)<br />
<br />
in the pages that need to access the cached recordset.<br />
<br />

</div>


The recordset usually exist only in the scope of the page.  Meaning if you load another page, recordset is no more.

You can however, cache recordset inside a Session variable, tho not advisable for scalability unless you have tons and tons of memory or only have very very few users.

To cache the recordset just assign it to as session and retrieve the session on another page before doing any operation on the recordset.

Initialization code:

Set Session("theRecordset") = myRS

where myRS is a valid recordset

then do:

Set myRS = Session("theRecordset")

in the pages that need to access the cached recordset.



<div>
<div class="content wysiwyg-content">
Hi, I'm using Visual Interdeve 6.0 to create an ASP application. &nbsp;Is it possible to create ONE recordset and manipulate it (add, delete, navigate, update) through many active server pages? &nbsp;I get a 'requires object' error whenever I try to reference the recordset from a page other than the one it is created. <br />
Help is appreciated, thanks!
</div>
</div>


Hi, I'm using Visual Interdeve 6.0 to create an ASP application.  Is it possible to create ONE recordset and manipulate it (add, delete, navigate, update) through many active server pages?  I get a 'requires object' error whenever I try to reference the recordset from a page other than the one it is created. 
Help is appreciated, thanks!

Sharing same Record Set across many ASPs

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.