cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
IsaiahA

PowerApps to connect to Microsoft Access

Submitted by Advocate III on ‎11-18-2016 11:42 AM

Could Microsoft support PowerApps connection to Microsoft Access (online)? 

 

Thanks, 

 

Isaiah A.

Status: Declined

Access Web Apps have been deprecated and are being turned off on October 1, 2018.  Here is the announcment from last year.  As has been pointed out on this thread, the backing store for AWAs is SQL Azure and you can obtain the SQL connection strings through the Access client.  

 

I have created a PowerShell script to make it easier to migrate AWA data (retains relationships, imports images, handles primary names, etc) to CDS available at http://aka.ms/cdsimport.

 

You can also obtain the .dacpac file for an AWA by saving out the database as a Snapshot file from within Access.  Instructions are available here.

 

At this time, there are no plans for PowerApps to connect to Access Desktop databases (.accdb files).  You can use the on-premises gateway to import data from these files to CDS.  There are many tools available for moving Access Desktop database data to SharePoint or SQL, a common location where both Access Desktop and PowerApps can connect to the data.

 

 

 

25 Comments (25 New)
Comments
Meneghino
Community Champion
Community Champion
‎05-14-2018 02:40 AM

My personal preference is for Azure SQL Database over CDS, for a number of reasons, including:

1) Azure SQL Database is more flexible

2) Azure does not tie you to PowerApps

3) Azure is much more mature (since it is basically SQL Server)

 

On the downside, it may be more difficult to implement RLS (row level security), but still very much possible.

Hairy_Drumroll
Advocate III
Advocate III
‎09-18-2018 04:28 PM

Idea originally floated nearly 2 years ago, any progress?

Audrie-MSFT
Power Automate
Power Automate
‎09-18-2018 05:25 PM

Adding @GregLi to update us on this status. Thank you for your patience.

GregLi
Power Apps
Power Apps
‎09-18-2018 07:03 PM
Status changed to: Declined

Access Web Apps have been deprecated and are being turned off on October 1, 2018.  Here is the announcment from last year.  As has been pointed out on this thread, the backing store for AWAs is SQL Azure and you can obtain the SQL connection strings through the Access client.  

 

I have created a PowerShell script to make it easier to migrate AWA data (retains relationships, imports images, handles primary names, etc) to CDS available at http://aka.ms/cdsimport.

 

You can also obtain the .dacpac file for an AWA by saving out the database as a Snapshot file from within Access.  Instructions are available here.

 

At this time, there are no plans for PowerApps to connect to Access Desktop databases (.accdb files).  You can use the on-premises gateway to import data from these files to CDS.  There are many tools available for moving Access Desktop database data to SharePoint or SQL, a common location where both Access Desktop and PowerApps can connect to the data.

 

 

 

Ambiga
Frequent Visitor
‎06-09-2020 01:36 AM

@Meneghino 

Couldn't find such options  "Manage within the Connections group" under File tab > Info Tab in MSAccess.