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