How to Open Microsoft Access Files Stored in SharePoint Online
Question details
Users need to open or preview Microsoft Access database files that are stored in SharePoint Online but encounter a preview message instead of the file content.
- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Attempting to view or open an Access database file directly within the SharePoint Online browser interface.
- Observed behavior
- SharePoint Online displays a message stating that browser previews are not available, which may lead users to believe the file is corrupted or there is a version issue.
Ensure you have the Microsoft Access desktop application installed on your computer, as SharePoint Online requires a local client to open and edit database files.
Download and Open the Access File Locally
Since SharePoint Online does not support browser previews for Access databases, you must download the file to your computer to open it.
The lack of a browser preview does not mean your file is corrupted or that there is a version compatibility issue. It is simply a current limitation of SharePoint's web interface for Microsoft Access files.
Open your web browser and navigate to the SharePoint Online document library where your Microsoft Access file is stored.
Locate the Access database file and hover over it, then click the circular checkmark icon on the left side to select the file.
Click the 'Download' button located on the top command bar of the SharePoint interface to save the file to your local drive.
Locate the downloaded file on your computer and double-click it to open it using the Microsoft Access desktop application.
Looking for a Lightweight, Free Alternative for Office Documents?
While Microsoft Access is required for specialized database management, WPS Office provides an excellent, free alternative for handling your everyday documents, spreadsheets, and presentations with high compatibility.
- 1. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install WPS Office: Run the downloaded installation file and follow the simple on-screen instructions to set up the software.
- 3. Start editing: Open WPS Office to instantly start creating or editing your Word, Excel, PowerPoint, and PDF files.
Frequently Asked Questions
Does the preview error mean my Access file is corrupted?
Not necessarily. The preview message in SharePoint Online simply means the platform lacks a built-in web viewer for Access files. If the file opens successfully in your local Microsoft Access desktop application, it is not corrupted.
Can I edit an Access database directly in SharePoint Online?
No, you cannot edit Microsoft Access databases directly within the SharePoint web browser interface. You must download the file or sync the library locally to modify it using the desktop app.
Why does SharePoint support previews for Excel but not Access?
SharePoint Online includes Office for the Web, which provides browser-based viewing and editing for Word, Excel, and PowerPoint. Microsoft Access is a complex database application that currently does not have a web-based equivalent in SharePoint.
How can I request browser preview support for Access files?
You can request this feature by submitting feedback directly to Microsoft through the official SharePoint feedback portal or UserVoice forums.
