Quit Macro Won't Work With Scheduled Tasks

[Guest]

I have a scheduled task to run at 4:30 each day. I set it to run a desktop
shortcut/link to an Access macro. The scheduled task begins and runs the
macro just fine. My problem is when it comes to the last command - the quit
Access command - in my macro. I get an error message that basically says it
can't close because I'm using visual basic.

???

Is there a way to use Scheduled Tasks with an Access macro that won't cause
it to hang on the quit (exit Access) command?

 

[John Nurick]

When you open the database manually and launch the macro, does it
invariably run to completion and close Access, or is some user
intervention needed (e.g. acknowledging a messagebox)?