Question

SQL command INSERT INTO into an MS Access Database (DB inside Control Room) does not work, but throws no error.

I'm running an INSERT INTO into an MS Access Database.

I'm not getting an error, but the INSERT process isn't happening.

The MS Access Database is in the Control Room.

When I tried the same SQL statement and process with the MS Access Database in my Desktop, it works (so I know the syntax is correct).

Any ideas/thoughts?

Userlevel 5

+9

Hello,

I request you to please validate the user who is trying to perform an insert action from Automation Anywhere has permission for the same.
Please check and share the bot agent logs which will help to find the root cause of this issue.

C:\ProgramData\AutomationAnywhere\BotRunner\Logs

If you have any questions please let me know.

Thank you,

Prabhakar Jha

Userlevel 5

+9

if you are still facing an issue then please create a support case

How to create a support case :

if you don't have access to the above link, email the AA Support team "apeopleopsteam@automationanywhere.com" to get access.

Sign up