Creating a Recordset Using an Existing Connection

You can create a connection and then use that connection to create multiple recordsets. This is more efficient than creating a separate connection for each recordset.

rs.Open "Course", MyExistingConnection, adOpenDynamic, 
adLockBatchOptimistic, adCmdTableDirect