Question

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

  • 18 April 2022
  • 2 replies
  • 32 views

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?

 


2 replies

Userlevel 5
Badge +9

Hello,

 

  1. I request you to please validate the user who is trying to perform an insert action from Automation Anywhere has permission for the same.
  2. 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
Badge +9

@Kirby Kang​ :

 

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

 

How to create a support case :

https://apeople.automationanywhere.com/s/article/How-to-create-a-support-case-in-service-cloud

 

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

Reply