cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
simms7400
Post Prodigy
Post Prodigy

Powerautomtion to trigger MS Access Sub, Function, Macro?

Hi Folks -

Is there a way to trigger an MS Access Sub, Function or Macro from a flow?  If none of the aforementioned, is there a way to at least open an MS Access DB so I can leverage an AutoExec?

 

Thanks!

3 REPLIES 3

Hi @simms7400 

 

There is no connector available for MS Access right now. If you think this should be added as a feature, you can raise an idea or upvote already existing ones here: https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

 

One other way you can do this is using Power Shell. You can write a script and that can connect to MS Access and then you can trigger the script from flow through an Azure Automation account. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

RobElliott
Super User
Super User

@simms7400 no, there are no Access connectors in Power Automate.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

ScottShearer
Super User
Super User

@simms7400 

As has been mentioned by @RobElliott and @yashag2255 there is no MS Access connector.  Can you explain a little more about your requirement and what you are trying to accomplish?

 

One option you have is to migrate/export your data to SharePoint and use linked tables in Access - MS Access will do this for you automatically.  Then, since the data lives in SharePoint, you can use Power Automate.  Since you have your Access tables linked to SharePoint, you can still use Access forms, reports, etc..

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,350)