Task Scheduler running a macro

[skennd]

Hello,

All your help is appreciated in this problem.

I am running a macro to execute certain queries and the macro is
started to run by a windows task scheduler. However, after the macro
runs the database will remain open. Instead I would like to close the
whole database after it completes the macro processes.

Here's how the current macro is tied with the task scheduler and I've
already tried adding /Exit at the end but that didn't help.




"C:\Program Files\Microsoft Office\OFFICE11 \MSACCESS.EXE" "\\ussd.loc
\data\bcd\Data\ DCIA\WorkGroup\ debit database.mdb" /X mcr_Red

[Salad]

Re: Task Scheduler running a macro

skennd wrote:

Hello,
>
All your help is appreciated in this problem.
>
I am running a macro to execute certain queries and the macro is
started to run by a windows task scheduler. However, after the macro
runs the database will remain open. Instead I would like to close the
whole database after it completes the macro processes.
>
Here's how the current macro is tied with the task scheduler and I've
already tried adding /Exit at the end but that didn't help.
>
>
>
>
"C:\Program Files\Microsoft Office\OFFICE11 \MSACCESS.EXE" "\\ussd.loc
\data\bcd\Data\ DCIA\WorkGroup\ debit database.mdb" /X mcr_Red

Add to the end of the macro the action
Quit
and option Exit

Diru Diru

http://www.youtube.com/watch?v=UOzpWTglhck