MDB File Viewer Microsoft Access for Mac
Microsoft Access for Mac
There is no Mac version, there never has been, and a Microsoft 365 subscription does not change that.
The short answer
Microsoft Access is a Windows application. Microsoft 365 plans that list Access include it for Windows only, so paying more does not produce a Mac version. Word, Excel, PowerPoint and Outlook all run natively on macOS. Access is the one that never made the trip.
That leaves three situations, and they want different answers.
If you need to build a database
LibreOffice Base is free and runs on macOS. It is the closest structural match to Access: tables, forms, queries, reports. The interface is dated and the learning curve is real.
FileMaker is the polished Mac-native option, from Apple’s own subsidiary until 2019. It is priced for businesses rather than individuals.
Airtable and similar cover the common case of a shared table with a form on the front. They are hosted, which matters if the data cannot leave your control.
If you need to run an existing Access database
The forms and the VBA behind them are the hard part. They assume Windows, and nothing on macOS reimplements them. Running Windows in Parallels with a real copy of Access is the honest answer here.
If you only need the data
This is the common case. Someone sent you a .mdb or .accdb and you need what is in the tables. You do not need Access, and you do not need a database platform.
Smart MDB Exporter opens the file on your Mac, lists the tables with their row and column counts, and writes them to CSV or SQLite. Encrypted .accdb files open with their password. A one-time purchase, and the original file is opened read-only.
Table view is a work in progress. The app reads the database and exports the data; browsing rows in place is the next thing being built.
Questions
- Does Microsoft 365 include Access on a Mac?
- No. Microsoft 365 plans that include Access include it for Windows only. Installing Microsoft 365 on a Mac gives you Word, Excel, PowerPoint, Outlook and OneNote. Access is not among them, whatever the plan costs.
- Was there ever an Access for Mac?
- Not for modern macOS. Access has been a Windows product throughout the era of Mac OS X and macOS, so there is no old version to hunt down.
- What is the closest thing to Access on a Mac?
- It depends what you used Access for. For building a small database with forms, LibreOffice Base or FileMaker. For querying data, any SQLite tool. For reading files someone else made in Access, a converter is a better fit than a whole database platform.