I created an Excel spreadsheet with a macro that just exits Excel
This spreadsheet works when executed directly or from a bat file but fails when the bat file is executed from a scheduled task - just like the Access front end
Soooo ... the problem is not with Access but with something in Windows that is not allowing an office application to run when called from a scheduled task - even if the task runs while I am signed in
When I look at the scheduled task after the run time it shows as running (0x41301)