sequential queries in pass throughs

[IRedsell]

I would like to use some of my already created and tested offline queries in my Access MDB that links to that MYSQL database already, I have MYSQL queries that have sequential queries delimited with a semi-colon ";" to terminate a query properly. It seems I can't use this in Pass Throughs, also (2nd question) can I use temporary tables or not?

I can't find any guidance on the web or in the access books or help files so I am in the dark. Thanks

 

[jedraw]

IRedsell

Not sure if I fully understand your terms, but I use multiple pass thru queries in Access against Oracle.
I also have a Pass Thtu query template, let's call it PassThru.

To run these queries "sequentially", the sql (in Oracle format) is stored in an access table (tblSQL). I have query name and sql as fields in this table.

Once I decide which queries I want to run, I set up a small Do while loop based on the Table containing the sql, and alter the PassThru.sql to be the sql of the query.

In effect. PassThru.sql = tblSQL!sql

I return data from the pass thru and process it in Access to do what I want. Then Loop to the next record in the tblSQL.

Hope this helps.