If this is the incorrect forum for this question, please let me know the
better place to post, but...

In Excel, I wish to build a dynamic table of criteria in memory and ==>
somehow make available to Access, to join against another table, via an
invocable query -- with results then brought back to Excel.

Approaches considered:
1.  Write criteria recs to a set linked text file from Access.
2.  Access table directly linked to an Excel tab area.

But I need the Access .mdb to potentially concurrently serve multiple uses
from a common network location -- where Excel is running locally on their
PC.  So I need a way to dynamically pass this criteria file such that Access
can run this same set query simultaneously, for different criteria sets.

So I need a more robust solution.  Any thoughts or ideas?  Thanks in
advance.  Larry.