Running a module with MS Scheduler

[davisto01]

Hi,

I'm trying to run a module that I've created using the windows scheduler.

This is what I have:
RUN:
"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\Program Files\Microsoft Office\Office\Samples\ Northwind.mdb" /x:AUTO_EXEC

START IN:
"C:\Program Files\Microsoft Office\Office\msaccess.exe"

I'm getting a message that says "Access cannott find macro AUTO_EXEC". I'm not concerned with macros right now. I'd like it to run the module.

Thanks!
TD

 

[CosmoKramer]

Try taking the colon off of the /x switch:

/x AUTO_EXEC

 

[mp9]

First off, I'd recommend using the freeware util HAL (Handy Access Launcher) rather than an MS Scheduler job. You can get HAL from

http://www.geocities.com/waddly/accory.html

Secondly, the /x command line parameter is used to open your db and then run a macro, hence the error mesasge saying Access cannot find a macro called Auto_Exec. What you need to do is create a macro with two actions, firstly a RunCode command (which takes your module name as a parameter) to run the module, then a Quit command to close Access after the module has finished running. Then start Access with /x YourMacroName here on the end of the command line.

Hope this helps.

 

[davisto01]

Hey, It works!!

Thanks!

You need the colon on the switch but you certainly want to point the scheduler to a macro that calls the code from the module.

Thanks also for the heads up on the freeware.

TD