Skip to main content
K
Kirbs
Cadet | Tier 2
April 18, 2022
Question

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

  • April 18, 2022
  • 3 replies
  • 483 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?

 

    3 replies

    A
    Automation Anywhere Team
    Automation Anywhere Team
    Automation Anywhere Team
    July 14, 2022

    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

    A
    Automation Anywhere Team
    Automation Anywhere Team
    Automation Anywhere Team
    October 8, 2022

    @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.

    V
    vick 1699
    Cadet | Tier 2
    September 17, 2023
    Problem: Database Insert command not working.
    Error: There is a syntactical error in the SQL statement. - SQL statement got timed out.
     
    I am using the AA Community edition. I am trying to Insert data into MS Access db. from excel.xlsx but getting an error, Please grant me access so I can build my bots. Thank you.
    My MS  access db. is connecting. I tested my DSN connection. Only the INSERT query not working.
     
    - Using MS Office 2016 professional edition, 32-bit.
    - ODBC driver successfully installed and connected 32-bit.
    -MS Access data types are correct .
     
    I successfully ran the same query in the Query design in MS Access which ran successfully and inserting data into db. table field.  
     
    Please let me know if you have any questions. Thank you.
    I also emailed on "apeopleopsteam@automationanywhere.com" to get access, still waiting for a reply. Please help. Thank you.
    Terms & ConditionsAccessibility statement