PowerApps to connect to Microsoft Access

[IsaiahA]

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

Thanks, 

Isaiah A.

[Meneghino]

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]

Idea originally floated nearly 2 years ago, any progress?

[Audrie-MSFT]

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

[GregLi]

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]

@Meneghino 

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