MDB File Viewer What Is an MDB File?
What Is an MDB File?
A single file holding an entire database: tables, relationships, and usually the forms someone built on top of them.
What is inside
An .mdb file is a Microsoft Access database. Unlike a spreadsheet, it is not one grid of cells. It holds:
- Tables. The data itself, in rows and columns, with a declared type per column.
- Relationships. Which table’s key matches which other table’s column.
- Queries. Saved questions asked of the tables.
- Forms and reports. The interface someone built so colleagues could use the database without seeing the tables.
When you need to get data out of an old Access file, it is almost always the tables you want. The forms were built for a version of Windows that is no longer around.
The file formats
.mdb | Access 2003 and earlier. The Jet database engine. |
|---|---|
.accdb | Access 2007 onward. Adds attachments and real encryption. |
.mde / .accde | Compiled builds. Forms and code locked, tables still readable. |
Why it will not open on a Mac
Microsoft has never shipped Access for macOS, and the database engine that reads these files is Windows-only. That is also why Excel for Mac cannot import them while Excel for Windows can.
So the file sits in your Downloads folder with a blank icon. The data is intact and perfectly readable; nothing on your machine speaks the format.
Getting the data out
The tables convert cleanly to CSV, which every spreadsheet opens, or to SQLite, which is a better home if the database has more than a couple of tables and you care about the relationships between them.
How to open an MDB file on a Mac walks through the four ways to do that, including the free ones.
Questions
- What is the difference between .mdb and .accdb?
.mdbis the older format, used by Access up to 2003..accdbarrived with Access 2007 and added attachment fields, multi-value fields and proper encryption. Access can still open.mdbfiles, and both formats hold the same kind of thing: tables, and the objects built on them.- What are .mde and .accde files?
- They are compiled versions, shipped when the author wanted the forms and code locked down. The tables inside are still readable, which is what matters if you are after the data.
- Can I rename .mdb to .csv or .xlsx?
- No. The extension is not what makes the file an Access database. It is a binary container with its own internal structure, and renaming it produces a file that nothing can open.
- Is Microsoft Access being discontinued?
- Microsoft still ships Access as part of some Microsoft 365 plans on Windows. It is not on the Mac and has not been for the whole modern history of macOS, which is why files like these turn up needing conversion.