What Is .mdb

Content on WhatAnswers is provided "as is" for informational purposes. While we strive for accuracy, we make no guarantees. Content is AI-assisted and should not be used as professional advice.

Last updated: April 11, 2026

Quick Answer: .mdb is a proprietary database file format developed by Microsoft for Access databases, introduced in 1996 with Access 97. Each .mdb file is a self-contained database supporting tables, queries, forms, reports, macros, and modules with a maximum capacity of 2GB. Although superseded by the .accdb format in 2007, .mdb files remain widely used in legacy systems and continue to be supported by modern versions of Microsoft Access.

Key Facts

Microsoft Access 97 introduced the .mdb format in 1996, making it the standard database format for Access for over 11 years until 2007
A single .mdb file can store up to 2 gigabytes of data, supporting tables, queries, forms, reports, macros, and modules in one self-contained file
The .mdb format was replaced by the .accdb format in Microsoft Access 2007, which offered improved security, encryption, and support for additional data types
An .mdb database file contains multiple objects including tables (data storage), queries (data retrieval), forms (user interface), and reports (formatted output)
Millions of legacy .mdb databases continue to operate in organizations worldwide, particularly in small to medium-sized enterprises and older business systems

Overview

The .mdb file format is a proprietary database file extension developed by Microsoft for use with Microsoft Access, a relational database management system included in the Microsoft Office suite. Introduced in 1996 with the release of Microsoft Access 97, the .mdb format became the standard file format for storing Access databases throughout the late 1990s and early 2000s. Each .mdb file is a complete, self-contained database that can include multiple objects such as tables, queries, forms, reports, macros, and modules, all packaged into a single binary file. The format was specifically designed to be portable and easy to distribute, allowing users to share entire databases as a single file attachment or transfer via storage media.

One of the defining characteristics of .mdb files is their maximum storage capacity of 2 gigabytes, which was considered substantial when the format was first released in 1996 but has become a significant limitation for larger modern applications. The .mdb format remained the default database format for Microsoft Access until 2007, when Microsoft introduced the .accdb format with Access 2007 as part of the Office 2007 suite. Despite being superseded by .accdb, millions of .mdb files continue to exist in organizations worldwide, particularly in legacy systems, small businesses, and enterprises that have not upgraded their database infrastructure. The format remains fully supported by modern versions of Microsoft Access for backward compatibility, ensuring that databases created in the 1990s and 2000s can still be opened and edited by current software versions.

How It Works

.mdb files function as complete database systems, storing data and related database objects in a structured binary format. The file architecture enables users to create, manage, and query data without requiring a separate database server:

Table Storage: Tables form the foundation of any .mdb database, storing structured data organized in rows and columns. Each table can contain millions of individual records, and relationships between tables can be defined to maintain data integrity and enable complex queries that join data from multiple sources.
Query Processing: Queries in .mdb files allow users to retrieve, filter, and manipulate data from one or multiple tables using SQL syntax. Queries are stored as named objects within the database file and can be executed repeatedly to produce result sets based on specific criteria or user parameters.
Forms and Reports: .mdb files can contain user interface components like forms for data entry and updates, as well as reports for professionally formatted data presentation. These objects are stored within the database file and provide customized views of the underlying data without modifying the actual tables.
Macros and VBA Modules: Users can automate database operations using VBA (Visual Basic for Applications) macros and custom modules. These executable components are stored in the .mdb file and can be triggered by various events such as button clicks, form loading, or scheduled execution.
Relationships and Integrity: .mdb files support defined relationships between tables, enforcing referential integrity constraints that prevent orphaned records and ensure data consistency across related tables. These relationship definitions are stored within the file and automatically enforced when data is modified.

Key Comparisons

Aspect	.mdb Format	.accdb Format	SQL Server Databases
Introduction Year	1996 (Access 97)	2007 (Access 2007)	1989 (SQL Server 1.0)
Maximum File Size	2 GB (hard limit)	2 GB (32-bit) or larger with SQL Server backend	Theoretically unlimited (terabytes)
Security Features	Basic user-level security model	Enhanced encryption, password protection, and field-level security	Advanced role-based access control and enterprise security
Data Type Support	Limited: Text, Number, Date/Time, Currency, Boolean	Extended: GUID, Attachment, Hyperlink, Calculated fields	Comprehensive: XML, Spatial, JSON, plus all standard types
Multi-user Support	Limited concurrent access via record locking	Improved concurrent access with better locking mechanisms	Full enterprise-level multi-user support with scalability
Modern Compatibility	Supported in Access 2016 and later for legacy access	Native support in all current Microsoft Access versions	Industry standard with universal support across platforms

Why It Matters

Legacy System Support: Countless organizations rely on .mdb databases built between 1996 and 2007. Understanding the format is essential for maintaining these systems, troubleshooting issues, and ensuring that critical business data remains accessible and protected from corruption or loss.
Data Recovery and Analysis: IT professionals, database administrators, and forensic analysts need to understand .mdb file structure to recover deleted data, investigate database corruption, repair damaged files, or extract information from database backups for analysis or compliance purposes.
Migration and Modernization: Organizations upgrading from .mdb to newer formats face significant challenges in preserving complex queries, custom forms, VBA macros, and business logic. Proper understanding of the format facilitates smooth migrations to .accdb, SQL Server, or other modern database platforms while maintaining data integrity and functionality.
Compatibility and Interoperability: While .mdb is proprietary to Microsoft, third-party tools and open-source libraries have been developed to read and write .mdb files, enabling data exchange with non-Microsoft systems, platforms, and programming languages. This interoperability is crucial for organizations using mixed technology environments.

The .mdb file format represents an important chapter in database history, serving millions of users and organizations for over two decades. While newer formats like .accdb and enterprise solutions like SQL Server have emerged with improved features, scalability, and security capabilities, .mdb databases continue to power critical business operations in many organizations, particularly small businesses and non-profits. For database administrators, IT professionals, and software developers, understanding .mdb files remains relevant for supporting legacy systems, ensuring data integrity during system migrations, and preserving institutional knowledge embedded in older databases. As technology evolves and organizations modernize their infrastructure, the ability to work with .mdb files—whether for maintenance, security, migration, or data recovery—remains a valuable skill in the modern technology landscape.