Home‎ > ‎StuffLearned‎ > ‎

Schedule MSAccess Task

posted Jan 21, 2014, 3:11 PM by Brian Grenier
Struggled to get a Task to work on Server 2008.
It turned out that I had multiple msaccess process running in TaskManager, so I was not seeing that they were throwing an error:


"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" 
Arguments: "C:\Program Files (x86)\UDD\UDDReports.accdb"   

Had an autoexec macro that ran code.
One module to delete the old file:
Public Function KillOOWListPost()
    Kill "C:\Out of Work\OOWListPost.pdf"
End Function