Quit Macro Won't Work With Scheduled Tasks

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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)?
 

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

Similar Threads

Msaccess.exe Running in the Task Manager 2
Scheduled Macro hanging 4
Using Scheduled Tasks to run Macros problem 2
macro process running in task manager after the job is done 3
Scheduled macro 5
Close Database Function? 2
MS Access and Window scheduled task 13
Access with CMD.EXE 4

Back
Top