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