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: Powered On
Hopefully this is coming soon. In the meantime, there is a (very) indirect way. If you have Access 2013 (or A2016), you can create an Access Web App. When you do this, your tables are automatically ported into SQL Azure (hosted by Microsoft). And a browser web app somewhat emulating your table structure is also created, but that's not important here. So ... you now have an SQL Azure back end which mimics your Access db (tables). You can connect to this back end in a Power App ... I've done this. You will also need (pretty sure) an Office 365. If you get an O365 account with Click To Run Office (including Access), you are good to go.
Level 10

@DatabaseMX then you have access to SQL Azure database Tables, NOT Queries! Also Flow does not trigger New/Update/Delete records in SQL Azure so PowerApps and Flow for SQL are so far a toy not real solution.

Level: Powered On
Like I said ... *VERY* indirect :-)
Level 10

@DatabaseMX Agreed my friend, i am only disappointed of Microsoft they give attention to things they want not things we want. for instance, Salesforce is fully supported, Azure is 5% supported. kind of awkward.

Level: Powered On

I have something that I am creating with Access Web apps. I started in 2014, then, I did not touch it again until now. I started looking into it after I checked up on PowerApps. While I won't neglect PowerApps, I will divert my attention to the Access Web apps for now. At least It has Macros, and the Form (View) is not bad. 

Level: Powered On
May I offer this suggestion ... Focus on Power Apps. Microsoft is putting a very serious effort in to Power Apps :-)
Level: Powered On

Thanks for the advice. I do not plan to leave PowerApps. As a matter of fact, I have three areas that I am focusing on: Access Web app, PowerApps, and Web application, using Microsoft MVC. I just have to divide myself into 3 and in addition to many more. I hope that MS will add MS Access  to the list of database that PowerApps can connect to. Thanks

 

Isaiah A. 

Level: Powered On
I would focus on only the two ... Power Apps and Web application. You can ... create a Web App for the purpose of getting an Access table structure into SQL Azure - which I have done in fact, so I can experiment with an SQL data source connected to a Power App. But ... I would not focus at all on the web side of Access Web Apps ... :-) "I hope that MS will add MS Access to the list of database that PowerApps can connect to." :-) :-)
Level 10

Yes, it is possible to connect to an Access Web App.  I assume that you know how to get the server, database, username and password information from Access, but if not here is how.

Enable Connections for your Access Web App

  1. Open the Access Web App in the Access client
  2. Click the File tab > Info > click Manage within the Connections group
  3. If your Access App is on SharePoint Online, select From Any Location or From My Location to allow connections. Note: If you are on an IPv6 network, you will only have the option to connect From Any Location. In an on-premise installation, these options are not available.
  4. Select either Enable Read-Only Connection or Enable Read-Write Connection
  5. Depending on the previous selection, select either View Read-Only Connection Information or View Read-Write Connection Information
  6. Copy and paste the Server, Database, UserName and Password values into Notepad or Word, or leave the Connection Information window open so you can copy and paste the information from it later.

 

Then in PowerApps the source type to use is SQL Azure, and you will be asked for the information that you just retrieved from the Access Web App.  It worked for me every time.

 

Level: Powered On

Meneghino:

 

Thank you very much for this information. Now that I know (from you)  Access Web App uses SQL Azure as backend. I will definitely try your approach. I really appreciate your response. May God bless you. 

 

Sincerely:

 

Isaiah A.