You are currently offline, waiting for your internet to reconnect

"You do not have permissions to view the records" error in Access web app

Symptoms
When you access a Microsoft Access app in your web browser, you may receive a "Request Not Complete, you do not have permissions to view the records" error message. This occurs when you try to view data from a table that's linked to a SharePoint list.
Cause
When you create the linked table for the Access app, you must provide authorization for the app to access the list, and this establishes a trust relationship. Changes that are made to the SharePoint list or to the Access app may break this trust.

you must provide authorization for the app to access the list which establishes a trust relationship
Resolution
To resolve this issue, use one or both of the following methods to re-create this trust relationship. Start with Method 1, and if that doesn't resolve the issue, go on to Method 2. 

Notes

  • In some scenarios Method 1 may prevent the error message, but you may still be unable to view data from your linked table. In that case, Method 2 should correct both issues.
  • Before you make any changes to the Access app, save a copy of the app, and include your data by using an App package. For more information, see Create an Access app.

Method 1

  1. Navigate to the SharePoint Site Contents webpage where your Access app is located.
  2. Click the ellipses (...) at the uppper-right corner of the app.
  3. Click Permissions.

    Click Permissions
  4. Click the here link from: "If there's something wrong with the app's permissions, click here to trust it again"
  5. Click OK.

    Click the here link from:

Method 2

  1. Open the Access app in Office Access by selecting Customize in Access from the settings gear icon in the app.
  2. Create a new linked table to the same SharePoint list that was previously linked.
  3. When you're prompted for authorization, click Trust It, and then click OK.

    Note After the new linked table is created, it will contain the list name with a "1" appended to it, because the table name already exists in the app.
  4. Delete the newly created linked table.

    You should now be able to use the original linked table and view its data.
Access app; Access web app; SharePoint list; linked table; trust; trust it; Access Services; Access 2013; Access 2016
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 3140416 - Last Review: 02/17/2016 23:29:00 - Revision: 2.0

Microsoft Access 2013, Access 2016, Access Services in Microsoft SharePoint Server 2013, Microsoft Access for Office 365

  • KB3140416
Feedback