| Extension | .mdb |
| Category | documents |
| Description | An MDB file, short for Microsoft Database, is a common format used in Microsoft Access applications. This file type acts as a database, storing structured data like tables, queries, forms, reports, macros, and Visual Basic for Applications (VBA) modules. These elements combine to create the database. MDB files can be password-protected. This format, known for its robust data storage and management capabilities, is frequently used in applications like accounting systems, inventory databases, and order management systems. |
| Technical details | An MDB file contains multiple components, including tables, fields, indexes, queries, forms, reports, macros, and VBA modules. Tables store records, each following a specific data format defined by the table. The table structures and their relationships enhance data organization. MDB files manage structured data within Microsoft applications. Users can create, modify, and delete data, run queries, and generate reports. They can also expand the database's functionality with macros and VBA modules. Password protection is available for data security. MDB files are typically limited to a few gigabytes in size by the file system. MDB files can be opened in Microsoft Access or specific Database Management Systems (DBMSs) that support this format. |
