I have a command line program (that I wrote) that I can run on Windows Server 2012. It connects to the MS SQL Database server on a different server which has a linked server to a Access database. It works fine when I just run this program from the command prompt.
However when this program is run using a scheduled task I get an error "The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "BackOffice" reported an error. Authentication failed."
The scheduled task is set to run under my login, the same login as I run the program at the command prompt, I have tried with "Run with highest privileges" turned off and turned on, but neither works.