| Extension | .mdb |
| Category | documents |
| Description | The MDB format, short for Microsoft Database, is a commonly used database format in applications created with Microsoft Access. An MDB file serves as a database for storing structured data, including data tables, queries, forms, reports, macros, and VBA modules that make up the database. MDB files can be secured with passwords to restrict unauthorized access to the data. This format is a robust tool for data storage and management, and is utilized extensively in creating various applications such as accounting systems, inventory databases, order management systems, and more. |
| Technical details | An MDB file contains tables, fields, indexes, queries, forms, reports, macros, and VBA modules. Tables hold records, with each record corresponding to a specific data format defined in the table. Data is stored based on the table structure and relationships between them, making it easier to organize. MDB files are used to store and manage structured data within a Microsoft application, allowing users to create, change, delete data, run queries, and generate reports. Users can also add macros and VBA modules to enhance database functionality. Additionally, users have the ability to set a password to protect data from unauthorized access. The size of an .mdb file is limited by the physical limitations of the file system, typically having a limit of several gigabytes. MDB files can only be opened in Microsoft Access or some specialized DBMSs that support this format. |
