07-06-2016 07:19 AM
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 ?
07-06-2016 07:54 AM
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.
07-06-2016 10:22 AM
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#...
03-31-2017 02:21 PM
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.
04-01-2017 12:07 AM
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.
04-19-2017 09:39 PM
AWAs will not allow new apps to be created starting June. It will be removed completely starting April 2018.