Blue Prism - MS Access DB Connectivity and Run Macros with Key-In Parameters

[himavantht]

Hello All,

We have a requirement to Run Macros from MS Access DB through Blue Prism.

I just want to request you guys to share info on these below questions if anyone worked in a similar case earlier or if they have knowledge on this one.

1. How to connect MS Access DB to BP? Do we need to create an object to go through spying method or do we have any VBO for MS Access DB to run macros?

2. If there is any way to run macros with VBO, When I run macro - It asks for the parameter(today's date) to key-in and then runs queries. So, is there any way to handle this?

Thanks in Advance!View attachment Macro.PNG

 

[gil.silva]

Hello himavantht,

Is it possible to spy MS Access, but it can be a pain in the ass, because of the DB instability which makes the application "Not responding" and unpredictable.
I have been interacting with MS Access without creating any BP object.

How?
Using the object: Utility - Environment
Action: Start Process
Inputs:

• Application: [path to your file, including extension .accdb]
• Arguments: "/X [name of the macro]"

Regarding the parameters, I never had such case so I can't help you with that, you can try:
/X [name of the macro] -[parameter]"

But, I'm not sure that it will work.
If you can do it, you can always create an object to interact with the Enter Parameter Value window.