Running Access Macros via SQL

  • Thread starter Thread starter J. Joshi
  • Start date Start date
J

J. Joshi

Hello all,

Is there anyway I could trigger an MS Access macro (a.k.a.
the Access Autoexec system macro) via the SQL Job
Scheduler?

If not, will I have to compile a store procedure? If yes,
then can you direct me to any available code if possible?

Is there any simpler way to run access macros via SQL?

Joshi
 
J. Joshi said:
Hello all,

Is there anyway I could trigger an MS Access macro (a.k.a.
the Access Autoexec system macro) via the SQL Job
Scheduler?

If not, will I have to compile a store procedure? If yes,
then can you direct me to any available code if possible?

Is there any simpler way to run access macros via SQL?

Joshi
Click to expand...

I'm not really familiar with the SQL Job Scheduler. If the Access
database isn't open, I'd assume all you need to do is start an instance
of Access to open it, and that would kick off the Autoexec macro -- or
ytou could use the /x command-line macro to run any macro you want. If
you want to do this in an instance of Access that is already open, the
only way I can think of is to run some program that uses automation to
get a reference to that instance of Access and executes the
DoCmd.RunMacro method from within that instance. But I've never tried
anything like this.
 
Back
Top