<div>
Actually, I was able to find the answer I was looking for by looking at another question. &nbsp;I'll post the answer I came up with and give juliette the pointsd just to add this to the archive.n &nbsp;This is part of a test system and to implement this in an n-tier application there will be modifications but I think the general idea is here.<br />
<br />
Dim rsTest As ADOR.Recordset, cmdTest As ADODB.Command<br />
Set cmdTest = New ADODB.Command<br />
Set rsTest = New ADOR.Recordset<br />
cn.Open (&quot;aps_test&quot;)<br />
cmdTest.ActiveConnection = cn<br />
cmdTest.CommandText = &quot;select f_name from employees&quot;<br />
cmdTest.CommandType = adCmdText<br />
rsTest.CursorLocation = adUseClient<br />
rsTest.LockType = adLockOptimistic<br />
<br />
rsTest.Open cmdTest<br />
Set rsTest.ActiveConnection = Nothing<br />
<br />
cn.Close<br />
rsTest.MoveFirst<br />
MsgBox rsTest(&quot;f_name&quot;)
</div>


Actually, I was able to find the answer I was looking for by looking at another question.  I'll post the answer I came up with and give juliette the pointsd just to add this to the archive.n  This is part of a test system and to implement this in an n-tier application there will be modifications but I think the general idea is here.

Dim rsTest As ADOR.Recordset, cmdTest As ADODB.Command
Set cmdTest = New ADODB.Command
Set rsTest = New ADOR.Recordset
cn.Open ("aps_test")
cmdTest.ActiveConnection = cn
cmdTest.CommandText = "select f_name from employees"
cmdTest.CommandType = adCmdText
rsTest.CursorLocation = adUseClient
rsTest.LockType = adLockOptimistic

rsTest.Open cmdTest
Set rsTest.ActiveConnection = Nothing

cn.Close
rsTest.MoveFirst
MsgBox rsTest("f_name")

<div>
<div class="content wysiwyg-content">
This should be very simple but I just can't seem to get my head around this. &nbsp;I need a way to open a recordset from the client side and close the connection to the database. &nbsp;I then want to be able to use the recordset to bind to a datasource for a report. I'll start this out at 30 points and increase depending upon the comments given. 
</div>
</div>


This should be very simple but I just can't seem to get my head around this.  I need a way to open a recordset from the client side and close the connection to the database.  I then want to be able to use the recordset to bind to a datasource for a report. I'll start this out at 30 points and increase depending upon the comments given. 

Disconnected recordset

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.