topic RE: MS Access Automation in Product Forum

MS Access Automation

Walter.Koller — Wed, 04 Sep 2019 11:22:00 GMT

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

RE: MS Access Automation

JohnCohen — Wed, 04 Sep 2019 15:01:00 GMT

Maybe you can try to spy them, with RegionMode?

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

RE: MS Access Automation

NagaM — Wed, 25 Sep 2019 12:02:00 GMT

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

RE: MS Access Automation

Walter.Koller — Thu, 26 Sep 2019 06:36:00 GMT

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

RE: MS Access Automation

NagaM — Thu, 26 Sep 2019 13:32:00 GMT

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

RE: MS Access Automation

Walter.Koller — Mon, 14 Oct 2019 14:38:00 GMT

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