"Could not execute query; could not find linked table" error message when you open an Access desktop database in SharePoint Online

Problem

When you try to open a Microsoft Access desktop database in Microsoft SharePoint Online, you receive the following error message:
 

  • Could not execute query; could not find linked table.

Solution

To resolve this issue, follow these steps:

  1. In the Microsoft Access app, create a new connection.

  2. In your Access desktop database, delete all linked tables.

  3. Relink the tables in the Access desktop database by using the information about the new connection for the Access app.

To create a new connection in the Access app and view the new connection information, follow these steps:

  1. Open the Access app in the Access client. To do this, follow these steps:

    1. Browse to the SharePoint Online site where the Access app exists.

    2. Click the gear icon for the settings menu, and then click Customize in Access.

  2. In the Access client, click File on the ribbon, and then click Info.

  3. Click Manage in the Connections section of the Info page.

  4. Disable the following settings if either or both are enabled:

    • Enable Read-Only Connection

    • Enable Read Write Connection

  5. Close the Access client.

  6. Reopen the Access app in the Access client.

  7. Click File on the ribbon, and then click Info.

  8. Click Manage in the Connections section of the Info page.

  9. Check to activate the following settings, as appropriate for your situation:

    • Enable Read-Only Connection

    • Enable Read Write Connection

  10. View the new connection information. To do this, click one of the following buttons:

    • View Read-Only Connection Information

    • View Read-Write Connection Information

  11. Re-create the linked tables in your Access database by using the new connection information that's listed.

If other users are connected to the same data in the Access app, you'll have to give them information about the new connection that you created in the previous steps.

NOTE: If you don't have the client version of the Access app, open the Access app in the Access client. To do this, follow these steps:

  1. Browse to the SharePoint Online site where the Access app exists.

  2. Click the gear icon for the settings menu, and then click Customize in Access.

More information

This issue may occur when you open an Access desktop database that has tables that are linked to an Access app in SharePoint Online.


Still need help? Go to Microsoft Community.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×