<div>
do you need further guidance here?
</div>


<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.<br />
<br />
I have recommended this question be closed as follows:<br />
<br />
Accept: Ryan Chong (<a href="https:#a42421025" rel="ugc">https:#a42421025</a>)<br />
<br />
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.<br />
<br />
Pber<br />
Experts-Exchange Cleanup Volunteer
</div>


No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Ryan Chong (https:#a42421025 [https:#a42421025])

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Pber
Experts-Exchange Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
objCommand.ActiveConnectio<wbr />n = objConnection &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'assignment to an existing ADO connection <br />
&nbsp; &nbsp; &nbsp; &nbsp; objCommand.Properties(&quot;Pag<wbr />e Size&quot;).Value = 1000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'set the Paged Results value to 1000 (AD standard)<br />
&nbsp; &nbsp; &nbsp; &nbsp; objCommand.Properties(&quot;Cac<wbr />he Results&quot;).Value = False<br />
<br />
Or<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; objRecordSet.CacheSize = 500<br />
&nbsp; &nbsp; &nbsp; &nbsp; objRecordSet.PageSize = 1000<br />
<br />
Or Both
</div>
</div>


objCommand.ActiveConnection = objConnection                              'assignment to an existing ADO connection 
        objCommand.Properties("Page Size").Value = 1000                          'set the Paged Results value to 1000 (AD standard)
        objCommand.Properties("Cache Results").Value = False

Or

        objRecordSet.CacheSize = 500
        objRecordSet.PageSize = 1000

Or Both

Do you Use PageSize on ADO Object Command or Recordset

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.