To All,
I have several extractions that run overnight on a server, using Access 2010 32 bit. I am calling macros using the command line, being initiated by the Windows Task Scheduler.
I have not been able to come up with a way to close the Access app when the extraction process completes. I have tried using the "Application.Quit" command from the VBA code, I have tried running the "Quit" command from the called macro. I have also tried running a batch file containing, "Taskkill /f /im msaccess.exe* /T". Nothing works reliably, except having a human being run the Task Manager each morning and closing several instances of "msaccess.exe" on the "Processes" tab, manually.
It seems to be that this should be something easy to do. We are running Windows Server 08 as the OS on the server.
Has anyone else dealt with this issue? Is there a good solution?
Thanks in advance for the help.
Sincerely,
Bill