Topic Thread

Expand all | Collapse all

MS Access Automation

  • 1.  MS Access Automation

    Posted 09-04-2019 12:22
    Hi,
    I am trying to automate MS Access DB/Application. 

    I tried to spy with Win32 but already had difficulties with the first step when switching tabs in the UI.
    The element class says oTabControl but element type is Window, with no actions available to click on a tab. I tried to trick Blue Prism by changing the element type to Tab but the navigate stage complains that the Action to change tabs is not supported by oTabControl.

    I could spy UI elements in UIA mode but I am not able to interact with them nor to highlight them again as Blue Prism does not respond if I try to do so. Both application navigator return an error message and show an empty list.

    AA cannot identify single elements like buttons, tabs, ... at all.

    Some hints are much appreciated :-)

    Regards

    ------------------------------
    Walter Koller
    Solution Manager
    Erste Group IT International GmbH
    Europe/Vienna
    ------------------------------


  • 2.  RE: MS Access Automation

    Posted 09-04-2019 16:01
    Maybe you can try to spy them, with RegionMode?

    ------------------------------
    Cohen
    ------------------------------



  • 3.  RE: MS Access Automation

    Posted 09-25-2019 13:02
    Hello Walter, 

    Can you please explain which are all the tasks you are preforming in MS Access DB ? 

    For data upload or download from MS Access DB you can use connection strings, which will work in background with out application interaction. Please check the link below. 

    https://www.connectionstrings.com/access/ 


    ------------------------------
    Naga
    Associate
    Asia/Kolkata
    ------------------------------



  • 4.  RE: MS Access Automation

    Posted 09-26-2019 07:36
    Thanks for the link.

    We already thought about accessing Access DB via OLEDB as the intention of the automation is to export a report. This is done by pressing a button on the Access UI.
    Unfortunately there is some logic behind this export button.

    Cheers

    ------------------------------
    Walter Koller
    Solution Manager
    Erste Group IT International GmbH
    Europe/Vienna
    ------------------------------



  • 5.  RE: MS Access Automation

    Posted 09-26-2019 14:32
    Edited by Naga 9 days ago
    Hi Walter,

    Are there any operation performing background after clicking on export button? 
    if yes, then you have to write a custom VB code to access UI elements in Access DB.

    ------------------------------
    Naga
    Associate
    Asia/Kolkata
    ------------------------------



  • 6.  RE: MS Access Automation

    Posted 10-14-2019 15:38
    Sorry for the late reply.

    I am not sure if I understood your approach correctly.
    Do you mean to recode the export logic into Blue Prism?
    Or to access UI elements via MS Access API?


    Thanks

    ------------------------------
    Walter Koller
    Solution Manager
    Erste Group IT International GmbH
    Europe/Vienna
    ------------------------------