cancel
Showing results for 
Search instead for 
Did you mean: 

PowerApps to connect to Microsoft Access

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.

 

 

 

Comments
Level 10

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.

Level: Powered On

Idea originally floated nearly 2 years ago, any progress?

Flow Staff

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

PowerApps Staff
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.