can I open two recordsets at the same time?

[GenocideOwl]

or do I need to close one, then open the other?

[Hack]

or do I need to close one, then open the other?

Oh sure. You could open 50 recordsets at the same time, although I have no idea why you would.

You do, however, need to give them different names.

Option Explicit
 
Private rsOwl As ADODB.Recordset
Private rsHack As ADODB.Recordset

[mikee_phil]

you can also use multiple recordset but microsoft jet doesnt support them

[GenocideOwl]

so, since I am using MSjet, I can't open two at once?

[mikee_phil]

you can declare two recordset like hack did but declaring 1 recordset and opening it with multiple queries is not supported by MSjet
eg:
rs.Open "SELECT * FROM table1 ;SELECT * FROM table2"

[GenocideOwl]

so I couldn't do say

Set cn = New ADODB.Connection 'we've declared it as a ADODB connection lets set it.
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= " & App.Path & "\CRTInventory.mdb" 'this is the connection string explained in the notes section.
cn.Open
Set rs = New ADODB.Recordset 'as we did with the connection
rs.Open bargeDB, cn, adOpenKeyset, adLockPessimistic, adCmdTable
rs2.Open "CRTInventory", cn, adOpenKeyset, adLockPessimistic, adCmdTable

[mikee_phil]

you can open recordset as many as you want using one connection
dim rs as adodb.recordset
dim rs2 as adodb.recordset
Set rs = New ADODB.Recordset
Set rs2 = New ADODB.Recordset
rs.Open bargeDB, cn, adOpenKeyset, adLockPessimistic, adCmdTable
rs2.Open "CRTInventory", cn, adOpenKeyset, adLockPessimistic, adCmdTable

[GenocideOwl]

ok, thanks