Integrate MS Access with Power Apps
I've been looking more into Power Apps, and I think it would be great for you to work with the Power Apps team to provide a web and mobile solution to what Access can do today on the premises of a server. Because there is unfortunately no web version of Access, maybe Power Apps can help solve this problem? Ideally, we should be able to continue moving (and linking) Access data into SQL and then create a Power App on top of the "Access-created" data from SQL; essentially viewing a Power Application that looks exactly like access but online and on the phone.
Anonymous
shared this idea
AdminMicrosoft Access Product Team
(Microsoft Access Product Team, Microsoft)
responded
This is great feedback that we are actually working on providing now. Using the comments below, we’d love to hear thoughts about solely focusing on SQL as a stepping stone to Power Apps for data migration purposes, or also investing in another way for you to connect to Power Apps through the Common Data Service (CDS). This database allows you to store, share and manage your data over the web, and eventually the phone (current MS investment). CDS is also Power Apps’ central underlying storage unit, as well as the entire Power Platform team’s key investment.
Please see following link for information about CDS, and let us know: if Access created a data export & linked table capability from our platform to CDS, would you use it?:
https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcommon-data-service%2Fdata-platform-intro&data=04%7C01%7CEbo.Quansah%40microsoft.com%7C32c26c86b7fe4f3162a508d7f069896d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637242208373640123%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C-1&sdata=GuvQ6o2aqKiBMs%2B1z2nvv0sNtAHNl8MPQqiOvsh0D1U%3D&reserved=0
We will still continue to make investments in SQL connection either way, but we are also happy to consider investing more in improving the SQL integration experience instead of also providing the CDS route. Please let us know thoughts!
6 comments
-
TJM
commented
Need the Access data connection, clients are not interested in the costs associated for the limited amount of data they have.
-
apurva bajaj
commented
The first time I visit your website and I am glad to found this article to keep sharing more blogs like this.
https://www.escortsindwarka.com -
Ernesto Manríquez Mendoza commented
ABSOLUTELY. By all means, make possible an upgrade path to CDS. Also, fix the Access SQL syntax so I can write the same SQL queries to control a CDS datastore and an Access database.
Once you do this, writing Power Apps using a CDS datastore with a backend designed in Access would be a snap.
-
James Rushforth
commented
Easy integration/connection with CDS would be fantastic. I could then build simple Power Apps for field workers from there that could connect to on prem Access database.
-
This is great feedback that we are actually working on providing now. Using the comments below, we'd love to hear thoughts about solely focusing on SQL as a stepping stone to Power Apps for data migration purposes, or also investing in another way for you to connect to Power Apps through the Common Data Service (CDS). This database allows you to store, share and manage your data over the web, and eventually the phone (current MS investment). CDS is also Power Apps' central underlying storage unit, as well as the entire Power Platform team's key investment.
Please see following link for information about CDS, and let us know: if Access created a data export & linked table capability from our platform to CDS, would you use it?:
https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcommon-data-service%2Fdata-platform-intro&data=04%7C01%7CEbo.Quansah%40microsoft.com%7C32c26c86b7fe4f3162a508d7f069896d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637242208373640123%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C-1&sdata=GuvQ6o2aqKiBMs%2B1z2nvv0sNtAHNl8MPQqiOvsh0D1U%3D&reserved=0We will still continue to make investments in SQL connection either way, but we are also happy to consider investing more in improving the SQL integration experience instead of also providing the CDS route. Please let us know thoughts!
-
Hoàng Tuấn Đoàn
commented
I agree. Come on Microsoft.