Say in my Access database I have 5 tables.
Now would I have to use a separete instance for each table
like

Set rstInfo = .OpenRecordset("Info")
Set rstCustomer = .OpenRecordset("Customer")
Set rstEmployee = .OpenRecordset("Employee")

Or could I put them all into once instance

Set rstInfo = .OpenRecordset("Customer" & "Employee" & "Info")

Or something like that, as I'm not sure how the 2nd way would work if it's possible.