Im trying to create a power app to connect to data stored in an access web app.
Is this possible?
Solved! Go to Solution.
I have tried to connect several times over the past months via the steps you provide. (my access web app is on SP online)
If I want to use the connection, I see a 'Default' dataset. When clicking the 'Default' dataset I get an error message: 'the tables did not load correctly, please try again'
any ideas ?
The best method I have is, enable the read/write connection within access and then create a DSN file in notepad using the following text:
DRIVER=SQL Server Native Client 11.0
Save the file with the extension .dsn
You can then load this as a file data source in access or wherever to create a linked table.
As with any linked table you will not be able to edit the table design.
Hi, actually an even simpler version of the connection string works for me and others, maybe you could try that
See this post for example https://powerusers.microsoft.com/t5/PowerApps-Forum/Data-from-SharePoint-lists-not-loading/m-p/3212#...
Hey, Julian. I'm late the the game since the death of AWA was just announced. I have two apps developed in AWA that we use all the time. But the system is built as a relaional db. I'm not seeing anything that addresses that. Everything looks like it is a single table app. I sure hope I'm missing something.
Can you please elaborate on the death of AWA? Do you have a link to any information?
We have a major app that we use all the time, this would be a disaster.
Thanks in advance.
AWAs will not allow new apps to be created starting June. It will be removed completely starting April 2018.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.