I have a form in Access that has some coding to pull data from diff locations.
The form is set to be executet on Start.
I created the scheduled task to execute the access every day .
When I right click and select "run" on the scheduled task it works perfectly.
However, on its regular schedule it is not working. Access is indeed opening, but it is not running propely. It starts to run and opens Access, but it would appear the form never runs and Access is remaining open, as if it is getting hung up. I have to go in and kill the MSAccess process.
When I run this process manually - it works perfectly.
Please help to solve the issue.