[AccessD] 365 Access web app connectivity question

[Martin Reid]

https://blogs.office.com/2013/01/22/visualize-your-access-2013-web-app-data-in-excel/

-----Original Message-----
From: "Jim Dettman" <jimdettman at verizon.net>
Sent: ‎06/‎01/‎2017 16:37
To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com>
Subject: Re: [AccessD] 365 Access web app connectivity question

See if this helps:

https://blogs.technet.microsoft.com/the_microsoft_access_support_team_blog/2
014/03/24/how-to-make-external-connections-to-an-access-web-app/

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Susan Harkins
Sent: Friday, January 06, 2017 10:44 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] 365 Access web app connectivity question

I have an E3 365 subscription, which comes with a SharePoint site. I
currently have a simple Access Web App shared on that site. 

 

I thought I could easily grab data from it using Excel 2016's Get and
Transform feature, but the attempt returns a connection error: Details:
"Microsoft SQL: Cannot open server "ssharkins.onmicrosoft.com" requested by
the login.  The login failed."

 

With just a bit of research I think I'm looking at a connection problem - or
more specifically a firewall setting. It's possible that I need an Azure
Management account, which is free with my sub, I just haven't done it
because I didn't need to. Apparently, I can configure my firewall as needed
using this account. Or, I need to configure the Windows Firewall to allow
the connection locally. In the end, that might not even solve the problem.
Perhaps I can sign in to my 365 account as an admin and flip a switch
somewhere - but I don't know which switch. I looked around but it's a needle
in a haystack for me. Perhaps I need to set a connection in Excel first -
but I haven't been successful doing that either. 

 

I'm no longer running SQL Server, so I don't have that management tool to
work with. 

 

Frankly, I just expected it to work - I didn't expect to have to jump
through any hoops. I have limited networking skills so I don't know what to
do next. I'd rather not waste a lot of time trying to figure that out. 

 

I know most of you aren't using Access Web Apps, but you might be working
with Azure, so I'm hoping someone will have some insight. Thanks for
considering it and I apologize if I'm not asking the right questions. I'm
obviously using the wrong search strings either because all I can find are
SQL Server connection discussions. It's like Excel's Get and Transform
feature doesn't exist within this context. 

 

Susan H. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com