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?
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!
@simms7400 no, there are no Access connectors in Power Automate.
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.
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..
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!