Reference

ACCDB (Access)

ACCDB is the database file format Microsoft Access has used since Access 2007. A single .accdb holds an entire desktop database — tables, queries, forms, and reports — replacing the older MDB format.

Files & formatsWindowsGeneral

ACCDB (Access)

Also known as: .accdb file, Microsoft Access database, Access 2007 format

ACCDB is the database file format Microsoft Access has used since Access 2007. A single .accdb holds an entire desktop database — tables, queries, forms, and reports — replacing the older MDB format.

  • Microsoft Access database format since 2007
  • Holds tables, queries, forms, and reports in one file
  • Successor to legacy MDB; export tables to CSV

What ACCDB contains

Unlike a spreadsheet, an Access .accdb packs a whole relational database into one file: the data tables plus the queries, forms, reports, and macros that make up the application around them.

ACCDB is the successor to the legacy MDB format and added features like multivalued fields and attachments. It is the default for modern Access databases.

Opening and exporting

Microsoft Access opens .accdb natively. Without Access, you typically export tables to CSV or Excel, or migrate the data into another database engine.

File size grows with the data and embedded attachments; Access offers a compact-and-repair step to shrink bloated databases. For sharing data, exporting to CSV is the simplest route.

Related terms

Keep reading the reference.