Unanswered

Building Power App on top of Access database with VBA tool

(0) Share

Report

Posted on by Chukke

At our company we have an extensive dataset with a large VBA application. Overall user satisfaction with this VBA application is high, but we do not want to add new features to an old program. However, we want to keep the VBA application with its current functionalities.

Now, we would like to use a PowerApp which uses the data in the Microsoft Access database. I was surprised to hear that it is not possible to connect our Access database to PowerApps. I found that it is possible to migrate the Access database to a Dataverse database, but following questions remain:

Would this mean we can no longer use our VBA application to modify and interect with the data in our Access database. Or is it possible to automatically sync the Dataverse database with our Access database so we keep the data identical?
If no, what are our options? Rebuild the VBA application in PowerApps with a Dataverse back-end?

I look forward to hearing your insights.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @Chukke, according to the documentation you can keep the link between Dataverse and Access tables. That means your users can still use the VBA to update the access data which will reflect in your Dataverse tables as well.

Once migrated, Access users can continue using their existing desktop client to manage their data. They're also able to use Power Platform to manage their data. Plus, they can:

Create applications for desktop, laptop, phone, and tablet.
Create automated processes based on the data and services in Dataverse or Dataverse for Teams.
Create AI-driven virtual assistants based on the data.
Perform deep analysis on the stored data using business intelligence.

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @Chukke ,

Overall I have worked with a number of Access and other legacy technology applications and migrated them to Model-Driven application with Dataverse backends. In general this is a great strategy long term to support growth, ability to leverage AI, strong security, etc. etc. etc.

Microsoft Access has some great capabilities as you know and I have had challenges in the past migrating to the Power Apps side. Specific areas of challenges have been in areas of the reporting, complex columns in Access, and UI complexity.

There is no option to utilize a Power App that leverages Access Database on the backend, it supports the opposite as mentioned by @AhmedSalih above.

Normally I see it as a "re-imagining" of the application and business processes and look at how it can be moved to a full Power Apps solution (usually primarily model-app but I have had great success with Custom Pages and Embedded Canvas Apps to help provide some advanced capabilities).

Was this reply helpful? Yes No
Chukke 2 on at

Like (0)

Report

Thank you @dpoggemann and @AhmedSalih for your replies.

Ahmed I agree that a complete overhaul would be an ideal scenario and it is the long-term path we are thriving to do.
Has any of you had any experience in running existing VBA applications in Access on the migrated Dataverse database? I know you can migrate, but I fear that the existing VBA applications would seize to work.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @Chukke

I have prototyped it only but there were a number of limitations when I completed. See the details herehttps://learn.microsoft.com/en-us/power-apps/maker/data-platform/migrate-access-to-dataverse

Overall this could be a first step and you could start from a copy of your Access database to see any issues that arise but rewriting to be cloud first would be the best solution in my opinion. I know this is sometimes a big effort though.

Was this reply helpful? Yes No