James Rushforth
My feedback
-
40 votes6 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →Need more info ·
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=0We will still continue to make investments in SQL connection either way, but we are also happy to…
An error occurred while saving the comment James Rushforth
supported this idea
·
-
413 votes
Thank you for your feedback. The Access team is currently looking into resizing Access applications, starting with forms. We will provide you with a notification when this is available, and will continue to work on additional resizing/zoom support within different areas of the product at a later time.
James Rushforth
supported this idea
·
-
193 votes10 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
We have presented in a recent user group session about an investment we are making in building a CDS Connector within the Access application, to successfully move your data to and from CDS; which will power a variety of Power App and MS Flow applications.
Check out the presentation here https://www.youtube.com/watch?v=x_o3F89EcBI, and scroll to the latter half of this video to hear more about CDS/Power Apps.James Rushforth
supported this idea
·
-
314 votes
Thank you for your feedback.
In terms of setting SQL Server as the default database format, that is currently not in scope for the Access product. We have provided and will continue to provide efficient methods to integrate your Access data with SQL server, and the team will continue to develop more features that streamline the data migration experience (see https://support.office.com/en-us/article/migrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979)
However, the ACE database engine has and will continue to be Access’s central data storage unit.
There are new features coming soon that will improve the Access: SQL experience, and we are excited to share this news. Please stay tuned! :)
James Rushforth
supported this idea
·
-
22 votesJames Rushforth
supported this idea
·
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.