>>Do stored procedures in Access97 exist?
>>>Can a module or a Macro in Access97 be fired by VFP through SQL PassThrough?
>>
>>
>>a) No, AFAIK. What you have is "action queries" or parameterized queries.
>
>How does one fire an "action query" through SQL Pass Through?
>I tried and attempted...
>
A regular query without parameters, you can do something like:
lnRes = SqlExec(lnHandle, "Select * From mySavedQuery")
For parameters you can just pass the SQL directly.
>
>>b) No, but you can do it through Access automation:
>>
oAccess.Run("SayHello") 'Run a public function or Sub
>>oAccess.DoCmd.RunMacro("My Macro") 'Run a macro
>>HTH
>
>Thank you very much for the help thus far...