'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Open and View an Access Database in Microsoft 365 Online
Question details
The user wants to open and view a Microsoft Access database file directly within the Microsoft 365 Online browser interface.
- Product
- Microsoft 365 Online
- Device & OS
- not provided
- Scenario
- Attempting to preview or collaborate on an Access database with team members via a web browser.
- Observed behavior
- Microsoft 365 Online fails to preview the Access database, as it treats the file as a container for queries, forms, and modules rather than a standard viewable document.
Verify whether you have the Microsoft Access desktop application installed on your local computer, as this is required to natively open and interact with database components.
Open the Database Using the Desktop Application
Since Access files are complex containers, you must use the native desktop application to properly view forms, queries, and reports.
An Access database is not a simple document like a Word file. It contains interrelated tables, macros, and modules that require the full desktop engine to execute and render.
Download the Access database file from your Microsoft 365 Online storage (OneDrive or SharePoint) to your local computer.
Open the Microsoft Access desktop application on your PC from the Windows Start menu.
Click on 'File' in the top-left corner, select 'Open', and navigate to the location of your downloaded database file to access all its components.
Export Access Tables to Excel for Online Viewing
If your team only needs to view the data without interacting with forms or running queries, exporting to Excel is the best workaround for browser-based access.
Browse Tables Using a Custom Web Application
For more advanced or interactive web access, you can connect the database to a web application viewer.
Easily View Exported Database Spreadsheets with WPS Office
Since Microsoft 365 Online cannot natively preview Access databases, exporting your data to Excel is the most practical solution. WPS Office provides a completely free, lightweight, and highly compatible alternative to Microsoft Office for opening, editing, and collaborating on those exported spreadsheet files with a familiar user interface.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your PC or Mac.
- 2. Open Exported Data: Launch WPS Spreadsheets and click 'Open' to load the .xlsx file you exported from your Access database.
- 3. Edit and Share: Easily analyze, format, and share your database records with team members using the intuitive ribbon interface.
Frequently Asked Questions
Why does Microsoft 365 Online preview Word files but not Access databases?
Word and Excel files are standard documents with straightforward content structures. An Access database is a complex container housing relational tables, macros, and executable modules that a simple web viewer cannot process without the underlying database engine.
Can I edit an Access database natively on a Mac?
No, Microsoft Access does not have a native macOS application. Mac users typically need to run Windows via Parallels or Boot Camp to use Microsoft Access, or simply view the exported database data in compatible spreadsheet software.
What is the best way to share Access data with non-Access users?
The easiest method is to export your tables or query results to an Excel spreadsheet (.xlsx) or a CSV file. These formats can be easily opened by anyone using Microsoft Excel, WPS Office, or standard web-based spreadsheet viewers.
