Excel Criteria Table => Access.mdb Join Query => Excel ?

[Larry Adams]

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.

 

[Stefan Hoffmann]

hi Larry,

Approaches considered:
1. Write criteria recs to a set linked text file from Access.

You need to get the data to Access:

Persist your recs in a new Excel sheet and use it as linked table in Access.

2. Access table directly linked to an Excel tab area.

This is a question for an Excel NG.

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.

Have you split your Access application into a frontend and backend? Each
user get its own frontend, so you could write your recs directly into
your frontend .mdb.


mfG
--> stefan <--

 

[Larry Adams]

Interesting idea, Stefan!! Should be very straight forward. And, no, I had
not considered. Thanks!