>>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...
>
Also with automation you can open a saved query and specify parameters but this will give you a DAO Recordset to work with.
>
>>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...