At One Place

.mdb files

.mdb file
Microsoft Access Database (legacy)
The pre-2007 Access database format, still common in old business systems.

What opens a .mdb file

Windows
Microsoft Access, LibreOffice Base (read via ODBC), MDB Viewer tools
macOS
Microsoft Access in a Windows VM (Parallels Desktop), mdbtools (via Homebrew)
Linux
mdbtools (mdb-export), LibreOffice Base (with mdbtools)

What a .mdb file is

MDB is the Jet database file used by Access up to 2003, holding tables, queries, forms and reports in one file. Access on Windows opens it, though recent versions dropped support for the oldest Access 1.0 and 2.0 files. There is no Access for macOS; on Linux the mdbtools utilities export the tables to CSV or SQL, which is usually enough to recover the data.

Converting it

A .mdb file is commonly converted to .accdb, .csv, .xlsx or .sql. It is a binary format, so a text editor will show unreadable characters rather than its contents.

Details

Extension
.mdb
Full name
Microsoft Access Database (legacy)
Category
Data
MIME type
application/x-msaccess
Created by
Microsoft
Format
Binary

Common questions

How do I open a .mdb file?
On Windows use Microsoft Access; on macOS use Microsoft Access in a Windows VM (Parallels Desktop); on Linux use mdbtools (mdb-export). The pre-2007 Access database format, still common in old business systems.
What is a .mdb file?
Microsoft Access Database (legacy). MDB is the Jet database file used by Access up to 2003, holding tables, queries, forms and reports in one file. Access on Windows opens it, though recent versions dropped support for the oldest Access 1.0 and 2.0 files.
Can I convert a .mdb file?
Yes. It is usually converted to .accdb, .csv, .xlsx or .sql, either by exporting from one of the programs listed above or with a format converter.

Related pages

Sources

  1. Media Types Registry — IANA
  2. Official vendor product documentation — At One Place

How these figures are compiled and checked