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.
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.
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.
- 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.
- Navigate to the SharePoint Site Contents webpage where your Access app is located.
- Click the ellipses (...) at the uppper-right corner of the app.
- Click Permissions.
- Click the here link from: "If there's something wrong with the app's permissions, click here to trust it again"
- Click OK.
- Open the Access app in Office Access by selecting Customize in Access from the settings gear icon in the app.
- Create a new linked table to the same SharePoint list that was previously linked.
- 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.
- Delete the newly created linked table.
You should now be able to use the original linked table and view its data.
Article ID: 3140416 - Last Review: Feb 17, 2016 - Revision: 1