Office 365: Microsoft Access Database Engine could not find the object


Symptoms


When you attempt to open a table, form, report, or query in a Microsoft Access 2010 Web database where the tables are hosted on Office 365, you may receive the following error message:

The Microsoft Access database engine could not find the object <table name>. Make sure the object exists and that you spell its name and the path name correctly. If '<table name>' is not a local object, check your network connection or contact the server administrator

Cause


This is a known issue caused by an upgrade to the server.

Resolution


To resolve this issue use either of the following methods. Note that if there are changes you have not yet synchronized to the server, you may need to recreate those changes after following the steps.

Method 1: Open in Access

1. Open the web site for the Access web database.

2. Select Options and click Open in Access.

3. Click OK

4. At the bottom of the browser, you will see the message "Do you want to open or save <filename>.accdw (##bytes) from <sitename>.<locationName>.com."   Click Open.

5. You will see a prompt: "Opening a Microsoft Access Web app (ACCDW) file will download information from the internet or intranet. The URL for the site association with this file is: https://<application site url>" . Click OK.

Your application will be open in Microsoft Access and you should be able to open your tables, forms, and reports.

See More Information if you need help locating the web site for the Access application.

Method 2: Delete the accdb file and Open in Access

If the steps in Method 1 do not resolve the issue, follow these steps to remove the accdb for the application from your local machine and create a new accdb file from the Office 365 web location of your Access application:

    Record file and Site Information:

1. Start Microsoft Access on your local machine and open the Access Web application. 

2. Click File and click the "View and edit database properties" link on the upper right. On the General tab of the dialog you will see the location of the local database file.

3. Record the location of the *.accdb file and close Access.

4. In the Sync All section on the File menu, click the link to the database on the web. You can leave the web site open or save the address of the site in a Notepad document when you are ready to create a new copy of the accdb from the web site.

    Backup and Delete the Problem accdb File:

Note: Any objects, such as forms or reports that were created after this issue began may need to be recreated if you did not sync the database after creating the objects. If you created client forms or client reports that were not synced, you may be able to import them from your backup copy.

5. Navigate to the location of the local Access accdb file you recorded in step 3 and select the file. Copy the file to a different hard drive or USB drive.

6. Delete the file from the local machine. Note that renaming the file will not resolve the problem. It must be removed from the machine.

    Create a New Copy of the accdb File from the Web on your Local Computer:

7. Navigate to the site of the web database that you opened or saved in step 4.

8. Click on Options on the top bar of the application and select Open In Access.

9. At the bottom of the browser, you will see the message "Do you want to open or save <filename>.accdw (##bytes) from <sitename>.<locationName>.com.   Click Open.

You will see a prompt: "Opening a Microsoft Access Web app (ACCDW) file will download information from the internet or intranet. The URL for the site association with this file is: https://<application site url>"

10. Click OK.

You will receive a message "Created a local copy of 'https://<your application site url>' at 'C:\users\<profile name>\Documents\Access Applications\<application name>.accdb."

11. Click OK.

You should see all your objects.

More Information


To locate the web site address for the Access web database:

In Microsoft Access, click File.

In the Sync All section on the File tab, click the link to the database on the web to open it in your browser. You can leave the web site open or save the address of the site in a Word or Notepad document.