I’m building a process that run a query in Access, and exports it out to an Excel file.
This works fine when the screen is not locked.
But when I run it with the screen locked, I get an error “Failure Creating File” when Access tries to export.
I made sure all my activities are able to run in the background.
The account has permissions to write to the folder that Access is outputting to.
I can’t figure out what is causing this error.
Any advice would be helpful.
Thanks in advance,