How to close MS Access application after running macros from scheduled tasks?

I am using Windows XP with Office 2003 to use a scheduled task.  This task run an Access macro and emails reports to several people.  This works fine.  My problem is that I run macros several times daily and each time MS Access applicationis opened.  How do I close the MS Access application after running a macro. Access opens only so many times before errors occur.
mcinhelpAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:

place this as the last command in the macro

docmd.quit

or application.quit
0
 
twintaiCommented:
OR add the quit action to the macros itself.
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.