How to connect to your Access Web App SQL backend directly via ODBC

If you are using our Sharepoint 2010/2013 Enterprise Solution with Access Services you have the ability to publish your web database to Access Services 2010 or create an Access 2013 Web App in Sharepoint. The problem with SharePoint 2013 Web Apps is that you cannot create and run reports on your data in the browser (like in 2010). The solution is to create a desktop Access frontend that connects to your webapp’s data.  Here is how you connect to your MS Access 2013 Web App with Access Hosting.

How to Report on your Access Web App from MS Access:

1. Go to your Web App in Sharepoint (on and click the “customize in Access” button to download an accdw file.

2. Open and log into your web app by opening the accdw file downloaded from your Access Hosting Sharepoint site.

3. Go to File->Connections (be sure that Read-Only Connection is checked) and click on Manage->View Read-Only Connection information.  Make a note of all the connection data.

Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk