So I finally got a new computer at work with Windows 7. I was previously on XP and had a few tasks scheduled to run nightly. Essentially they were set to open Access databases at night, then the Access database would run a macro to update all my tables.
I have been unable to get the Windows 7 task scheduler to complete the tasks. I have been able to get it to open a Word document from my desktop, but can't get it to open Access. Any suggestions?