Can't run Access query in the background

access

#1

Hello,
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,
Ian


#2

Is your robot configured as unattended robot? If not then i don’t think that an attended robot works with the system locked.

Not sure if it works, but did you try using ‘Launch Workflow Interactive’ to invoke your workflow file.

Thanks,
Rammohan B.


#3

Hi Rammohan91,
Yes my robot is configured as unattended.

I have a separate process that runs forms from Access.
Those forms can be run in the background and output Excel files.

I have not used Launch Workflow Interactive before.
Do I just put all of by steps in it?

Thanks for your response,
Ian