Access ACTION queries cannot be called in a SELECT query such as:
"SELECT * FROM qdeDeleteRecipe"
To call an Access ACTION via ODBC, use the Call statement in SQLExec:
"{Call qdeDeleteRecipe}"
The statement needs to be enclosed in {curly} braces.
The Call statement can be used to Call SELECT queries, the resulting Recordset being accessible in the normal way.
See Also