>What I'd like to do ... is .. run a MakeTable query in Access97....
>I'd like to fire it via "SQL PassThrough"
>If this is not possible I am going to use Automation and a macro to perform a MakeTable Query and Fetch the resulting table via SQL Pass Through.
>
>Do you know how to fire a Make Table Query via SQL Pass Through ?
OK, you can use the CALL statement for queries too:
lnRes=SQLExec(lnHandle, "{CALL myMakeQuery}")
Should be able to run a make table query (no parameters).HTH
update:(correction for SQLExec call)