SUBMIT A FILE TYPE CONTACT US SUPPORT ABOUT US

What Is an ACCDB File? Versions, Limits and How to Open One

An ACCDB file is one Microsoft Access database, with its tables, queries, forms and reports. Jump to your question below, or work through it in order.

26 min read Updated October 2026 Checked against Microsoft guides, the mdbtools notes and 61 sample files

What Is an ACCDB File? One Access database, stored in a single file

Short answer

An ACCDB file is a Microsoft Access database. It stores tables, queries, forms, reports and macros in one file, in the format Access 2007 introduced to replace MDB.

Every ACCDB file starts with the same 19 bytes: 00 01 00 00 and the text Standard ACE DB. Access 2003 and older cannot open one, and Access itself works only on Windows.

Double-click your ACCDB file to open it in Access. No Access? See the free ways to open an ACCDB file on Windows, Mac and Linux.

An ACCDB file is one Microsoft Access database saved in the format Access 2007 introduced. Tables, queries, forms, reports and macros all live in the same file.

Picture a shop owner who hands you a file called customers.accdb and says the old PC is gone. The customer list is in there, plus the orders and the forms used to enter them. You double-click the file. Windows asks which app should open it. Most ACCDB file problems start with that question.

An ACCDB file is the default database format of Microsoft Access, from Access 2007 onward. It replaced the older MDB format. A spreadsheet stores loose sheets, but an ACCDB file bundles linked tables, saved queries, entry forms, printable reports and macros together, so copying one file copies the entire app.

The format belongs to the Access Database Engine, called ACE. Microsoft first shipped it with Access 2007 and has kept the .accdb ending in every release since. Access 2003 and older cannot open an ACCDB file or link to its tables, as the Microsoft guide to choosing file formats in Access 2007 states.

Access 2007 brought the new format for a reason. It added multivalued fields, an attachment data type, append-only history for memo fields and closer links to Outlook and SharePoint. Encryption got stronger too. Access 2010 then added calculated columns. The versions section shows how the format changed after that.

Access works only on Windows, so an ACCDB file is a Windows-first format. Free readers open it on other systems, and the list of apps and viewers names them.

ACCDB file facts at a glance

Quick facts about the ACCDB file format
Property Value
File extension .accdb
What it contains One Access database: tables, queries, forms, reports, macros and VBA code
Made by Microsoft Access 2007 and later, on Windows
Engine Access Database Engine (ACE)
Replaces MDB, the format of Access 2003 and earlier
Maximum size 2 GB, minus the space system objects need
File signature Bytes 00 01 00 00 followed by the text Standard ACE DB. In hex: 00 01 00 00 53 74 61 6E 64 61 72 64 20 41 43 45 20 44 42
Opens in Microsoft Access, Access Runtime, Excel (data import) and viewers like mdbtools

Wrong page? If your file ends in .mdb, read the MDB file page. If it ends in .mdf, that is a SQL Server data file, so read the MDF file page.

What Is Inside an ACCDB File? A 19-byte signature, then 4,096-byte pages

An ACCDB file is a stack of 4,096-byte pages. Page one is the header, and the other pages store table rows, indexes and the catalog that lists every object.

Open an ACCDB file in Notepad and you see mostly noise. That is normal, because the file is binary. The first bytes are the only part a person can read, and they name the Access engine that wrote the ACCDB file.

First 32 bytes of a real ACCDB file, taken from the 61 samples
0000  00 01 00 00 53 74 61 6E 64 61 72 64 20 41 43 45  ....Standard ACE
0010  20 44 42 00 02 00 00 00 B5 6E 03 62 60 09 C2 55   DB......n.b`..U

The first four bytes are a start marker. The next 15 spell Standard ACE DB. One empty byte follows, then the format code. Here it is 02, which means Access 2007. Older MDB files spell Standard Jet DB in the same spot, as the mdbtools format notes explain.

The first bytes of an ACCDB file labeled: start marker, engine name, format code, sub-version and encryption info length
The header of an ACCDB file, with the byte offsets that matter. Offsets are in hex.
Header fields of an ACCDB file
Offset Size Meaning
0x00 4 bytes Start marker 00 01 00 00. All 61 sample ACCDB files start with it.
0x04 15 bytes Engine name. Standard ACE DB in Access 2007 and later, and Standard Jet DB in MDB files.
0x14 1 byte Format code: 02 for Access 2007, 03 for Access 2010, 05 for Access 2016 and 06 for Access 2019.
0x15 1 byte Sub-version. It rises to 01 when the file gains a newer feature and never drops back.
0x299 2 bytes Size of the encryption info block. It reads 0 in files without a password.

The offsets come from the mdbtools format notes. We checked every one against our 61 sample ACCDB files in the sample study, and all of them matched.

Everything after page one lives in 4,096-byte pages. All 61 sample ACCDB files had a size that divides by 4,096 exactly.

A size that does not divide that way is a warning sign, because a cut-off ACCDB file almost always ends in the middle of a page. To check, right-click the ACCDB file, select Properties and divide the size in bytes by 4,096.

What lives in the pages

Tables and rows Your rows live in data pages. A large table spans thousands of pages.
Indexes Indexes speed up searches and keep keys unique. They are stored as separate pages in the same file.
Queries, forms, reports and code Access keeps these objects inside the ACCDB file too, so one file contains the app and its data.
System tables Tables with names that start with MSys keep the catalog and other housekeeping data. Access hides them by default.

All 60 samples that mdbtools could open have the same 18 system tables. They include MSysObjects, MSysQueries, MSysRelationships and MSysAccessStorage. Nine of them, named MSysComplexType plus a data type, back the multivalued and attachment fields that Access 2007 added. They appear even in tiny test files that use neither. With mdbtools, the command mdb-tables -S lists them.

Which Access Versions Write an ACCDB File? One ending, four format codes and a gate for newer features

Every Access release since 2007 writes the .accdb ending, but the code inside the file changed at Access 2007, 2010, 2016 and 2019. An older Access refuses a file that uses newer features.

Think of the ending as a label and the header code as the real age. Two ACCDB files can look the same in File Explorer and still need different Access versions. The table lists the codes we found at byte 0x14 and the Access release that writes every one.

Access versions and the format code inside their ACCDB files
Access version Released Code What to know
Access 2007 Jan 2007 02 First ACCDB format. It added multivalued fields, attachments and CryptoAPI encryption. It left out user-level security and replication.
Access 2010 Jul 2010 03 Added calculated columns. Newer encryption and sort orders push the sub-version to 01.
Access 2013 Jan 2013 03 Wrote the Access 2010 format. The mdbtools notes list code 04 for it, but no file has ever been seen with that code.
Access 2016 Sep 2015 05 New code. The Large Number data type arrived in build 16.0.7812.
Access 2019 and 2021 Sep 2018 and Oct 2021 06 Both report themselves as Access version 16, so there is no Access 17.

Release months come from the Microsoft Access entry on Wikipedia. Format codes come from the mdbtools notes and our samples. We found no public sample ACCDB file from Access 2024 or newer Microsoft 365 builds, so we list no code for them.

What an older Access does with a newer ACCDB file

The mdbtools format notes call the sub-version byte a forward gate. A database raises it when it gains a newer feature and never lowers it. Three states exist in practice, and the figure shows what Access 2007 SP2 does with every one.

Three header states: 02 00 opens in Access 2007, 03 00 opens with one object read only and 03 01 is refused by Access 2007 SP2
The three states of bytes 0x14 and 0x15, and what Access 2007 SP2 does with every one.

Version trouble also happens inside one Access generation. Microsoft documents an ACCDE file saved in Access build 8625.2017 or later that Access 1709 and earlier cannot open. The older version reports that the database is in an unrecognized format. The fix is to update Office, reopen the source ACCDB file and make the ACCDE file again, as the Microsoft support article on this error explains.

Check the version first. An unrecognized database format message does not always mean a damaged ACCDB file. Rule out the Access version before you try a repair.

What Do 61 Sample ACCDB Files Show? Where we got them, and how two readers compared

We checked 61 sample ACCDB files from three open-source projects. All 61 share the same 19-byte signature, and one free reader opened 60 of them while another opened only 39.

The samples come from the test files of three open-source projects. Jackcess and UCanAccess are Java tools for Access databases, and Apache Tika is a content-extraction toolkit. We downloaded the files in October 2026 and compared their checksums. No two matched, so every ACCDB file in the count is different.

The three sample sets behind the 61 ACCDB files
Sample set Files What it adds
Jackcess test files 42 Index, deleted-row, date and linked-table tests in Access 2007 and 2010 formats, plus one Access 2019 file
UCanAccess test files 17 SQL function, naming and data type tests, with one file made in Access 2016
Apache Tika test files 2 One ACCDB file without a password and one protected by a password

Two independent readers opened every file. The first is mdbtools 1.0.0, a command-line toolkit written in C. The second is access_parser 0.0.6, a Python library. We listed the tables, exported all of them to CSV and counted the rows.

61 ACCDB files read
177 user tables
269,088 rows exported
18 system tables in every file

Which Access versions wrote the sample ACCDB files

Format codes in the 61 sample ACCDB files
Header bytes Access version Files
02 00 Access 2007 33
03 00 Access 2010 format, nothing gated 6
03 01 Access 2010 format with a gated feature 20
05 00 Access 2016 1
06 00 Access 2019 1

Access 2007 wrote more than half of the files. Twenty of the 26 files with code 03 have sub-version 01, which is the gate that makes Access 2007 refuse a file. The reader results below depend on it.

How the two readers compared on ACCDB files

Two free readers on the 61 sample ACCDB files
Reader Opened Failed
mdbtools 1.0.0 60 1
access_parser 0.0.6 39 22

mdbtools failed only on the password-protected file. access_parser failed on 22 files with the same error message every time.

The access_parser failures follow a pattern. All 22 are files with code 03 and sub-version 01, plus the one Access 2016 file and the one Access 2019 file. It opened all 39 files from Access 2007 and from the standard Access 2010 format. We did not look into the cause.

The takeaway is simple. When one tool calls an ACCDB file damaged, try another tool before you believe it.

What the counts say about ACCDB files

One signature All 61 files begin with 00 01 00 00 and the text Standard ACE DB. We found no exception, so the signature works as a first test.
A key that is not a lock Sixty files share the same nonzero value at 0x3E, and all of them open without a password. In an ACCDB file that value is normal.
Encryption shows at 0x299 Only the protected file has a length there, 1,055 bytes. The other 60 read 0. Its signature still reads Standard ACE DB.
Small files, never empty The median size is 416 KB and 58 files stay under 1 MB. The smallest has one table with one row and still weighs 312 KB. The largest is 10.6 MB.
The same 18 system tables Every readable file has 18 system tables, and 14 also include an MSysCompactError table. Across the set we saw 30 different system table names.
Names with symbols One sample has 15 tables with spaces, punctuation and Greek letters in their names. Both readers handled them, so a strange name is no sign of damage.

Read the counts with care. Most of these files were built to test readers, and none came from a business. The counts show what a reader must handle, not how common a case is in daily Access use.

Check the header of your own ACCDB file

Python reads the first bytes of any ACCDB file in five lines. Replace sales.accdb with your file name. The code prints the engine name, the format code, the sub-version and the encryption info length.

Read the header of one ACCDB file with Python
import struct
head = open("sales.accdb", "rb").read(0x300)
print(head[4:19].decode("ascii"))
print("format code", head[0x14], "sub-version", head[0x15])
print("encryption info length", struct.unpack("<H", head[0x299:0x29b])[0])

An unprotected Access 2007 file prints Standard ACE DB, then format code 2 with sub-version 0, then a length of 0. A length above 0 means a password protects the file.

What Does Our Expert Say About ACCDB Files? A note from Neeraj Singh on what goes wrong most often

When an ACCDB file will not open, try a second tool before you repair anything. The file is rarely the problem.

Neeraj Singh

Expert insight

“Most ACCDB files that people call broken are fine. The reader or the Access version is the problem. In our 61 samples, one free reader opened 60 files and another opened only 39. The files did not change, so the tool made the difference. Compact and Repair can cut data from a damaged table, so I never start there. Copy the file, then open the copy in a second tool.”

Neeraj Singh Manager, Tech Support & Operations 19+ years fixing Windows and system errors

The one protected ACCDB file in our samples

One Apache Tika sample is locked with a password. Its signature still reads Standard ACE DB, so the first bytes say nothing. The clue is at 0x299, where the encryption info length reads 1,055 and not 0. Its sub-version byte is 01 too.

mdbtools stopped on that file with a message that page 2 is not a valid table definition. access_parser failed as well. The message sounds like damage, but the data is only locked. Keep the password with the file, because Microsoft cannot retrieve a lost one.

Copy before you test. Work on a copy of your ACCDB file. A failed repair can cut data from a damaged table, and the copy keeps the original safe.

How Do You Open an ACCDB File? Routes for Windows, Mac and Linux, plus viewers

Double-click the ACCDB file to open it in Microsoft Access. No Access? Install the free Access Runtime, import the tables into Excel or use a free viewer.

An ACCDB file is built for Access, so Access is the best route. It is a Windows program, and Microsoft makes no version for Mac or Linux. Other routes cover most needs. They let you look inside an ACCDB file without paying for anything.

On Windows

  1. Double-click the ACCDB file. Access opens it and may show a security banner.
  2. If Windows asks which app to use, select Microsoft Access and choose Always.
  3. If the ACCDB file opens in the wrong app, right-click it, select Open with and choose Access.
  4. Open a table from the Navigation Pane on the left to see your data.

No license for Access? The Microsoft 365 Access Runtime is free. It opens an ACCDB file in runtime mode, so forms and reports work, but the design tools are gone. The Microsoft download page for the Access Runtime explains the 32-bit and 64-bit choice.

On a Mac, Linux or the web

Microsoft makes no Access for Mac. Volunteer answers in a Microsoft Q&A thread on Access for Mac point to Windows inside Parallels or VMware Fusion, or to Power Apps.

For a quick look at tables, use mdbtools. It is free and reads ACCDB files from Access 2007 on. It works on Linux and macOS. The first command lists the tables. The second writes one table to a CSV file.

List tables and export one with mdbtools
mdb-tables -1 sales.accdb
mdb-export sales.accdb Customers > customers.csv

LibreOffice Base reaches an ACCDB file through the UCanAccess driver, which needs Java. Community guides cover that setup, so we skip the steps here.

Apps that open an ACCDB file

Microsoft Access Windows Double-click the ACCDB file. Full design and editing.
Access Runtime Free Opens the ACCDB file in runtime mode, with no design tools.
Excel Import Brings tables in through Get Data. A provider error means the 32-bit and 64-bit builds do not match.
mdbtools Linux and Mac Command-line reader. Lists tables and exports them to CSV.

Excel is the route for a quick look at one table. Select Data, then Get Data, then From Database, then From Microsoft Access Database. Microsoft documents the connector in its Power Query guide to the Access database connector. It imports data and does not edit the ACCDB file.

Free ACCDB viewers

With no Access on the PC, a viewer is the fastest way in. SysTools Free MDB Viewer opens an ACCDB file, lists the tables and shows the rows.

SysTools Free MDB Viewer

Opens MDB and ACCDB files with no Access needed

Free tool

SysTools lists Windows 7 to 11 and needs no Access. MDB Viewer Plus, a portable freeware reader, opens an ACCDB file only when the Access 2007 engine or a newer one is on the PC.

Reading an ACCDB file from your own code

Programs reach an ACCDB file through the Access Database Engine. The ODBC driver is named Microsoft Access Driver (*.mdb, *.accdb), and the OLE DB provider is Microsoft.ACE.OLEDB.12.0. Microsoft ended support for the older 2016 engine download on 14 October 2025. It now points to the Microsoft 365 Access Runtime, as the Microsoft Access Database Engine download page states.

Why Will an ACCDB File Not Open? Six causes, and only one of them is the file

When an ACCDB file will not open, check the app, the Access version, the file build, the size, the password and the name. Only one of those checks points to a damaged file.

Most failures come from the setup around the file. A damaged ACCDB file is the rarest cause, so work through six before you blame the sender.

No app on the PC can open the ACCDB file Windows has no Access and no Runtime, or the computer is a Mac. Install the free Runtime or choose one of the ways to open the file.
Your Access is too old Access 2003 and older cannot open an ACCDB file, and Access 2007 refuses files that use a newer feature. Update Office or use the Microsoft 365 Runtime.
An ACCDE file came from a newer build Files saved in Access build 8625.2017 or later do not open in Access 1709 and earlier. Update Office, then make the ACCDE file again from the source.
The ACCDB file is damaged or cut off A copy that stopped part-way has a size that does not divide by 4,096. Copy the ACCDB file again from the source. If the source is damaged, try a repair on a copy.
A password protects it Access asks for the password when you open the ACCDB file. Without it the data stays locked, and Microsoft cannot retrieve a forgotten password.
The file is not an ACCDB file A renamed MDB file or a download page saved with the wrong ending can end in .accdb. A real ACCDB file shows Standard ACE DB in its first 19 bytes.
A decision chart: if an ACCDB file will not open, check the app, the Access version, the build, the size, the password and the header
Six symptoms and the first fix to try for every one. Only the size check points to a broken file.

A six-step check

  1. Check the size. A file of 0 KB has nothing in it, and a size that does not divide by 4,096 was cut off.
  2. Show file extensions and confirm the name ends in .accdb, not .accdb.txt or .zip.
  3. Look at the first bytes. Standard ACE DB means an ACCDB file, and Standard Jet DB means an MDB file.
  4. Compare the format code at 0x14 with your Access release in the version table.
  5. Open the ACCDB file in a free viewer or in mdbtools. A table list means the file is readable and the first app was the problem.
  6. Copy the ACCDB file, then try Compact and Repair on the copy.

How to use Compact and Repair on an ACCDB file

Compact and Repair rebuilds the ACCDB file and fixes what it can. It may also cut data from a damaged table, so back up the ACCDB file first. The Microsoft steps for compact and repair cover both cases below.

  1. Copy the ACCDB file to a safe folder, and make sure nobody else has it open.
  2. If the ACCDB file opens, select File, then Info, then Compact & Repair Database.
  3. If it will not open, start Access, create a Blank database, close it, then select Database Tools and Compact and Repair Database. Choose your file.
  4. Access saves a repaired copy in the same folder. Open it and check your tables. If a repair works only in part, Access records the objects it could not fix in a system table.

A .laccdb file is a lock file. Access creates it beside a database that is open and deletes it when every user closes the database. It tracks users and stores none of your data.

Is It Safe To Open an ACCDB File? The data is safe to read, and the risk is the code inside it

The data in an ACCDB file is safe to read. The risk is the macros and code it can contain, so open files from strangers in a viewer first.

An ACCDB file stores more than tables. It can contain macros and VBA code, and Access can start that code when you open the file and allow it. A viewer only reads the stored tables, so no code starts.

Reading tables in a viewer Nothing starts. mdbtools and the free viewers only read the stored tables.
Opening an ACCDB file in Access after a download On Windows, Access blocks macros in files from the internet by default. A Security Risk banner says so, and it has no Enable Content button.
Unblocking an ACCDB file you do not trust The Unblock box removes the protection. Use it only for an ACCDB file from a sender you know.
Opening an ACCDE file An ACCDE file has compiled code only, so you cannot read its VBA before you open it.

The block comes from the Mark of the Web, a tag Windows adds to files from the internet. It applies to NTFS drives only. The Microsoft page on blocked internet macros lists the apps it covers, and Access is one of them.

How to unblock an ACCDB file you trust

  1. Right-click the ACCDB file and select Properties.
  2. On the General tab, tick Unblock and select OK.
  3. Or use PowerShell, with your own path in the command below.
  4. Open the ACCDB file again.
Unblock one file in PowerShell
Unblock-File -Path "C:\Data\sales.accdb"

A safe routine for unknown ACCDB files

  1. Ask why the sender needs you to open a database. A good answer comes quickly.
  2. Scan the ACCDB file with your antivirus before you open it.
  3. Open it in a viewer and read the table names and rows.
  4. Open it in Access only if the data looks right, and leave macros blocked.
  5. Delete the ACCDB file if the sender cannot say why it needs macros.

Protect your own ACCDB files too. Encryption works only on the .accdb format, and you set it with the file open in exclusive mode. Microsoft cannot retrieve a forgotten password, as its guide to encrypting a database with a password warns.

How Does an ACCDB File Differ From MDB and ACCDE? Six endings, and what every one is for

An ACCDB file is the modern Access database. MDB is the older format, ACCDE is a locked copy of an ACCDB file and MDF belongs to SQL Server.

Access uses a family of file endings, and they are easy to mix up. The table lists the ones you meet next to an ACCDB file.

Access file endings you meet next to an ACCDB file
Ending What it is Good to know
.accdb The standard Access database from Access 2007 on It replaces MDB.
.mdb The database format of Access 97, 2000 and 2002-2003 Access 2007 can still create one. Older Access cannot open an ACCDB file.
.accde An execute-only copy of an ACCDB file with compiled code Users cannot view the code or change forms and reports.
.accdt An Access database template The Save As Database Template add-in makes one from a database.
.accdr An ACCDB file renamed to open in runtime mode Rename it back to .accdb to restore full function.
.laccdb The lock file Access makes while a database is open Access deletes it when every user closes the database.

The Microsoft guide to Access 2007 file types defines every ending in the table. It also lists the features compared in the next block.

ACCDB or MDB: which one should you use?

ACCDB wins when

You work in Access 2007 or later and want multivalued fields, attachments, CryptoAPI encryption or links to Outlook and SharePoint.

MDB wins when

Your team still uses Access 2003 or older, or your app needs replication or user-level security. An ACCDB file supports neither.

Microsoft advises ACCDB for most databases. When you upgrade from an old Access, convert the file and keep the original MDB file as a backup, so you can check the result. The Microsoft advice on which Access file format to use says the same.

An MDF file is a different thing. It is the main data file of SQL Server, which is a database server. Access cannot open it. Read the MDF file explained if that is your file.

The ending can mislead. A file renamed from .mdb to .accdb is still an MDB file inside. Its header says Standard Jet DB and not Standard ACE DB, so check the bytes before you trust the name.

How Do You Convert an ACCDB File to MDB, Excel or CSV? Four routes, and what you keep in every one

Save As makes an MDB copy, Export makes an Excel or text file and SSMA moves tables to SQL Server. Every route makes a copy and leaves your ACCDB file as it was.

A conversion always makes a new file, so keep your ACCDB file untouched. Compare table names, row counts, dates and attachments before you trust a big job.

What you keep when you convert an ACCDB file
Target Tables and rows Queries Forms and reports VBA code
MDB Yes Yes Yes Yes
Excel Yes Results only No No
CSV One table per file Results only No No

The MDB row works only after you remove the features MDB lacks, which the next steps list. A spreadsheet or a CSV file keeps data and never the app around it.

ACCDB to MDB

  1. Open the ACCDB file in Access and select File.
  2. Under File Types, select Save Database As.
  3. Choose **Access 2002 - 2003 Database (*.mdb) or Access 2000 Database (*.mdb)**.
  4. Enter a file name and select Save. Access closes the original and opens the copy.

Four features block the conversion until you remove them: multivalued lookup fields, the Attachment data type, the Calculated data type and Long Text fields that track history. Delete links to ACCDB tables, Excel worksheets and SharePoint lists. Remove any password too. The Microsoft steps to convert an ACCDB database to an earlier format list them all.

That article does not say which Access releases still offer the MDB targets for an ACCDB file. Check the Save Database As list in your own version first.

ACCDB to Excel or CSV

  1. Open the ACCDB file in Access, then open the table or query you want.
  2. Select External Data, then Excel or Text File in the Export group.
  3. Choose a file name and format, then select OK.
  4. Open the new file and check the dates and the long text.

Access also exports to other targets, and the Microsoft overview of importing, linking and exporting data lists them. No Access? The mdb-export command shown among the apps that open an ACCDB file saves a table as CSV. We exported 191 tables from 60 sample ACCDB files this way, and none failed.

ACCDB to SQL Server

SQL Server Migration Assistant for Access, called SSMA, moves Access databases to SQL Server and Azure SQL. Choose this route when your ACCDB file outgrows Access or you need more users than it allows. The Microsoft overview of SSMA for Access explains what the tool covers.

Keep the original. Copy your ACCDB file before the first test and convert the copy. If a result looks wrong, you can try again from the same starting point.

Why Does an ACCDB File Stop at 2 GB? The limits, and three ways around them

An ACCDB file can grow to 2 GB, minus the space system objects need. When you near that size, compact the file, link tables from a second file or move the data to SQL Server.

The 2 GB ceiling is the limit most people hit with an ACCDB file. Our largest sample is 10.6 MB, so the ceiling matters only for big, long-lived databases. The table lists the other limits too.

Limits of an ACCDB file
Limit Value
Database size 2 GB, minus the space system objects need
Objects in a database 32,768
Concurrent users 255
Fields in a table 255
Table and field name length 64 characters
Short Text field 255 characters
Long Text field 65,535 characters in the interface, or 1 GB of storage when code fills it
OLE Object field 1 GB
Indexes in a table 32, including indexes Access makes for relationships

Every limit of an ACCDB file in the table comes from the Microsoft Access specifications page.

Three ways around the 2 GB limit

Compact the ACCDB file Compacting removes unused space, including room left by deleted objects. Back up first, because the same tool can cut data from damaged tables.
Link tables from other Access files Microsoft suggests this workaround. Your main ACCDB file stays small, and every linked file can grow to 2 GB.
Move the data to SQL Server Use SSMA when the data keeps growing. Access can then link to the server tables.
A main ACCDB file linked to three data files of up to 2 GB, and a path from Access to SQL Server
One main ACCDB file can link tables stored in other files, so total data can pass 2 GB while no single file does.

What Is the ACCDB File Format Made Of? The specification facts we could check

Microsoft has not published the byte layout of the ACCDB file format, as far as we could find. The facts below come from Microsoft guides, the mdbtools notes and our 61 samples.

This section is for readers who want the specification and not the how-to. Skip it if you only need to open an ACCDB file. Every fact traces to a source listed at the end.

ACCDB file format specification
Property Value
Extension .accdb
Engine Access Database Engine (ACE)
First release Access 2007, January 2007
Replaces MDB, written by the Jet engine
Signature 00 01 00 00 then Standard ACE DB
Format code at 0x14 02 for Access 2007, 03 for Access 2010, 05 for Access 2016 and 06 for Access 2019
Sub-version at 0x15 00 or 01. The value 01 marks a feature Access 2007 SP2 must refuse.
Page size 4,096 bytes
Maximum size 2 GB, minus the space system objects need
Encryption Password encryption through Windows CryptoAPI. The encryption info length is at 0x299.
Maintained by Microsoft
Public specification None found from Microsoft. Open-source projects documented the layout.

About the file signature

The first four bytes 00 01 00 00 also begin TrueType font files and MDB files. The text after them settles the question: Standard ACE DB for an ACCDB file and Standard Jet DB for an MDB file. Use all 19 bytes together, because four alone match too much.

What we left out

We list no format code for Access 2024 or Microsoft 365, because we found no sample ACCDB file. We say nothing about how the encryption works beyond the mdbtools notes. We also give no media type for the ACCDB file, because we could not confirm a registered one against a primary source.

Sources checked

For file types and features, the Access 2007 file format guide from Microsoft. For limits, the list of Access specifications. For the repair steps, the Microsoft compact and repair article.

For macros, the Microsoft note on blocked macros. For passwords, the Microsoft article on database encryption. For release months, the Wikipedia entry for Microsoft Access. The header notes come from the mdbtools project, and the sample study read 61 ACCDB files from the Jackcess, UCanAccess and Apache Tika test sets.

Frequently Asked Questions About ACCDB Files

What is an ACCDB file?

An ACCDB file is a Microsoft Access database. It stores tables, queries, forms, reports and macros in one file. Access 2007 introduced the format and replaced MDB with it. Every release since then writes the same .accdb ending.

How do I open an ACCDB file?

Double-click the file to open it in Microsoft Access. Without Access, install the free Microsoft 365 Access Runtime or use a free viewer. Excel can also import the tables through Get Data. On Linux and macOS, mdbtools reads the tables.

Can I open an ACCDB file without Microsoft Access?

Yes. The free Access Runtime opens the file in runtime mode, and free viewers list the tables and rows. Excel imports tables, and mdbtools exports them to CSV. None of these change the design of your database.

Can I open an ACCDB file on a Mac?

Not in Access, because Microsoft makes no Access for Mac. Volunteer answers on Microsoft Q&A suggest Windows inside Parallels or VMware Fusion, or Power Apps. For a quick look at the tables, mdbtools works on macOS.

What is the difference between ACCDB and MDB?

MDB is the older Access format, used by Access 97 to 2003. ACCDB arrived with Access 2007 and adds multivalued fields, attachments and stronger encryption. MDB supports replication and user-level security, and ACCDB supports neither. Access 2003 and older cannot open an ACCDB file.

What is an ACCDE file?

An ACCDE file is an execute-only copy of an ACCDB file. It has compiled code only, so users cannot view the VBA or change forms and reports. Keep the source ACCDB file, because the ACCDE file keeps only compiled code.

Why will my ACCDB file not open?

Check six causes. They are no Access on the PC, an Access version older than the file, an ACCDE file from a newer build, a cut-off copy, a password and a wrong ending. Open the file in a second tool before you repair it. Back up first. Compact and Repair can cut data from a damaged table.

Is an ACCDB file safe to open?

The data is safe to read. The risk is in macros and VBA code. Access on Windows blocks macros in files from the internet by default. Open files from strangers in a viewer first, and scan them before you use Access.

How big can an ACCDB file be?

An ACCDB file can grow to 2 GB, minus the space system objects need. Microsoft suggests linking tables from other Access files, and every linked file can grow to 2 GB. Moving the data to SQL Server is the next step when linking is not enough.

How do I convert an ACCDB file to MDB?

In Access, select File, then Save Database As. Choose Access 2002 - 2003 Database or Access 2000 Database. The conversion fails until you remove multivalued fields, attachments, calculated fields and history-tracking Long Text fields. Access saves a copy and leaves the original ACCDB file as it was.

How do I convert an ACCDB file to Excel or CSV?

In Access, open the table, select External Data, then Excel or Text File. Without Access, the mdb-export command in mdbtools saves a table as CSV. Forms, reports and VBA code do not travel to Excel or CSV.

How do I repair a corrupted ACCDB file?

Copy the file first. Then use Compact and Repair from File and Info, or from Database Tools in a blank database if the file will not open. Repair may cut data from damaged tables, so try a second reader before and after.

Still Stuck With an ACCDB File? Seven routes out, depending on what went wrong

Your ACCDB file will not open

Start with the six causes. The app, the Access version and the file build explain most cases.

You need another format

Go to the MDB, Excel and CSV steps. SQL Server has its own route there.

Does your file end in .mdb and not .accdb? That is the older Access format. The MDB database file guide shows how to open it.

Is it an .mdf file from SQL Server? The SQL Server MDF data file guide explains that format.

Do you work with dBASE tables? Read the DBF database file guide for that older format, which Access can import.

Do you need a small database with no server? The SQLite database file guide covers one.

Do you want the data from an ACCDB file in a spreadsheet? Export it with the Excel and CSV steps. If the workbook ends in .xls, read the Excel XLS file guide.

Not sure the file is an ACCDB file at all? Compare its first bytes with the header fields table, then read the sample study results to see how two readers differ.

Is it a file type you do not know? Browse the file extension resource library, or tell us about it on the submit a file type page.