Is it possible to have VB invoke a procedure that resides in an Access
97 database? I know it's easy to invoke action queries using the
"DBName.Execute QueryName" syntax, but even though I've tried to do such
things as create a reference to the MS Access 8.0 library, then use
Access.DoCmd.OpenModule (ModuleName, ProcedureName), I can't get it to
work (same with .DoCmd.RunMacro, where the Macro calls the procedure).

The reason for all of this is that I'm placing the database onto a
remote server that doesn't have Access 97 installed. I would like to be
able to have my VB program conditionally invoke a procedure that would
use the SendObject method to e-mail an Access report to various
recipients (in RTF).

Thanks in advance for any help.

Dale