I have a routine for calculating values based on variables sent to it (in a BAS)

The problem is that it requires to lookup about 8 files using syntax like

Select * from mytable where x = y

To achieve this I say STRSQL = "Select * from mytable where x = y"

Then I say

Set RSMyTable = DBCalc.OpenRecordset(StrSql, dbOpenDynaset)

This repeats for each table then I close the tables

How can I leave the tables open and still use the

syntax Select * from mytable where x = y

I tried using the DB.Execute STRSQL but it doesn't like that

Other than closing the Table, is there a way to do this (so that I can reduce the number of Opens and Closes and hopefully have a faster calculation routine)