Receiving an error when scheduling Macros from Windows Task schedu

S

shun

I have a macro that quits the application, it works fine if I click the run
command from access, but when I use the windows task scheduler to run this
macro I receive a warning, stating: If you're running a Visual basic module
that is using OLE or DDE, you may need to interrupt the module. Can any one
help me with this issue
 
S

Steve Schapel

Shun,

What are the actions in the macro? What is the command line you are
using for the scheduler?
 
S

shun

In my macro the actions are:

SendObject (to send a snapshot of a report)
Quit (to quit the application)

my command line is : "C:\Documents and Settings\alic\Desktop\Shortcut to
Schedule Macros in AssemblyInstructionDatabase.MAM"
 
S

Steve Schapel

Shun,

Your scheduler command line should be in the equivalent of this syntax...
"C:\Program Files\Microsoft Office\...\Msaccess.exe"
"C:\PathToDB\YourDb.mdb" /x NameOfMacro

I recommend the name of the macro to not have any spaces in it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top