Pass-through query to make-table query at the server
Posted on 2006-04-25
I have an MS Access 2003 database at the (not-my-own) server where Access is not installed (nor it will be).
I would like to run a make-table query (very "complex") included in it, via (ASP) code, to create a table in the same Access database that is linked with many other "common queries" (I need this because of time-of-processing issues).
The process should be: the user presses a button in the website, the ASP code deletes the "table X" (it already works) , the code triggers the make-table query and the (potentially different, updated) "table X" is (re)created at the database and instantaneously used for the "common queries" related to that...
In another EE post, I was suggested to "convert my macro into a store procedure that can be executed via ADO" and looking a bit more on the matter, it seems to me that a pass-through query from the Access database to itself could do the magic. Is is so?
In the positive, could you please help me to fill the "Select Data Source" Access dialog? I have no idea what should I put in "Data Sources" or in "DSN name", for instance.
In the negative (that is, if I should not use the pass-through query method) , how could I proceed? (Provide me with some instructive links, for instance.)
Thanks a lot,