Microsoft Access macro from Windows service

[Joe K]

I'm trying to launch a process from a Windows service that runs a Microsoft
Access macro. I'm having some trouble and wondering if anyone knows whether
this is technically possible (since a service does not have a UI).

Thanks in advance.

Joe

 

[Pat Hartman \(MVP\)]

You can pass the name of the macro you want to run as an argument if you
open Access from a .bat file. For example

"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "C:\Program
Files\Microsoft Office\Office11\Samples\Northwind.mdb" /yourmacroname

Do yourself a favor and don't use spaces or special characters in your macro
name.

 

[John W. Vinson]

On Wed, 21 Mar 2007 13:23:09 -0400, "Pat Hartman \(MVP\)" <please no

You can pass the name of the macro you want to run as an argument if you
open Access from a .bat file. For example

"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "C:\Program
Files\Microsoft Office\Office11\Samples\Northwind.mdb" /yourmacroname

Do yourself a favor and don't use spaces or special characters in your macro
name.

Pat, shouldn't there be an X command line switch in there?

"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "C:\Program
Files\Microsoft Office\Office11\Samples\Northwind.mdb" /x yourmacroname

John W. Vinson [MVP]

 

[Pat Hartman \(MVP\)]

Good catch. Thanks.

On Wed, 21 Mar 2007 13:23:09 -0400, "Pat Hartman \(MVP\)" <please no


Pat, shouldn't there be an X command line switch in there?

"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "C:\Program
Files\Microsoft Office\Office11\Samples\Northwind.mdb" /x yourmacroname

John W. Vinson [MVP]