Unable to open tables within an MSAccess Database

Question

Unable to open tables within an MSAccess Database

Terri Licari-DeMay 0

I created an MSAccess database that contains four tables in it. While I can open the database, and see the tables I created and have been using, I am suddenly unable to open any of the tables.

Why is this happening?

What steps can I take to open these tables?

0 comments

3 answers

Your answer

Answer 1

Karl Donaubauer 3,851 MVP

Hi,

In the Access title bar I see that the database is saved on Onedrive, which could be the reason for the problem. Onedrive's caching mechanisms are not meant or ideal for Access and can cause damages and unexpected locks, especially if there is more than 1 user or workstation involved.

If you have a local drive then try to copy the database file from Onedrive to it and check if you can open the tables locally.

Servus
Karl

0 comments

Answer 2

Terri Licari-DeMay 0

Thank you for your assistance. It is very much appreciated.

I can open the MSAccess DB and view a list of the tables within the database. The database is very simple one (no linked fields, tables, pick lists, etc.)
However, when I click on a table to open it, nothing happens. Note: since submitting my request & powering down & back up I was able to open the Notes table once.
This is the first time that I have had this issue. The database and the tables within it have always opened without any problem, (prior to the last MS update)
There is no system generated error message
I have tried compact and repair
I have tried importing the tables into a new database
I have shut down my computer & restarted
File Path: [Moderator note: Personally Identifiable Information removed]
I was able to export the table data to MSExcel

User's image

Jack-Bu 7,045 Reputation points Microsoft External Staff Moderator

2026-10-20T19:51:47.05+00:00

Hi Terri,

Thank you for providing the detailed information.

Based on what you've described, this does not appear to be a case of table corruption, as you are still able to see all tables in the Navigation Pane, export the data to Excel, and were able to open the "Notes" table once after restarting the computer.

First, follow this article Bypass startup options when you open a database | Microsoft Support to bypass the database's current configuration settings

OneDrive synchronization may be contributing to the issue. Microsoft Access databases are designed to work with local files and do not handle cloud synchronization as seamlessly as Word or Excel documents. If the database is stored in a OneDrive-synced folder, OneDrive may occasionally lock or interfere with the file during synchronization, which can lead to unexpected behavior. This could explain why the "Notes" table opened successfully once after a restart but could not be opened afterward. Please copy the database to a local folder such as:C:\Temp\orC:\Users\<username>\Documents\. Open the copied database and test whether the tables can be opened normally.

In some cases, Office updates can affect how Access handles databases stored in locations that are not designated as Trusted Locations. It is worth verifying that the folder containing the database has been added to Access's Trusted Locations.

As a best practice, avoid running a live Access database directly from shared or synchronized locations such as OneDrive, Dropbox, or network shares. While these locations are suitable for backups, the active working database should be stored on a local drive to help reduce the risk of corruption and improve overall performance.

Please try the suggested workaround and let me know the outcome in the comment in this post if the issue persists
Jack-Bu 7,045 Reputation points Microsoft External Staff Moderator

2026-10-21T21:29:48.08+00:00

Hi Terri,

Have you had a chance to review the information provided? Any updates would be greatly appreciated.

Answer 3

Hi Terri,

To better understand the issue and provide the most accurate guidance, could you please share a bit more information?

What happens when you try to open a table? Do you receive any error message? If so, please provide the exact wording or a screenshot of the error.
Can you open the tables in Design View? Please right-click one of the tables and select Design View, then let us know whether it opens successfully.
Are the tables local tables or linked tables? Also, are you able to open other database objects such as forms, queries, reports, or macros, or is the issue affecting those as well?

Any additional details about when the issue started or any recent changes to the database environment would also be helpful.

If possible, please include screenshots, as they can greatly assist with the investigation.

Thank you for your patience and cooperation. I look forward to your reply and will be happy to assist further. Should you have any additional questions, please feel free to respond to this post.

Note: If you would like to receive email notifications related to this topic, please follow the steps in the forum documentation to enable such notifications.