>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...


>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...