Don't!
Use ADO/SQL.

With ADO, you can just have one table open at a time, or many in separate recordsets, or whatever you want.

If you refuse, then you need a new RecordSet for each table. Trust me, use ADO.