| Extension | .mdb |
| Category | documents |
| Description | The MDB (Microsoft Database) format is a standard database format used in applications developed using Microsoft Access.
An MDB file is a Microsoft Access database used to store structured data. An MDB file contains data tables, queries, forms, reports, macros and VBA (Visual Basic for Applications) modules that make up the database. MDB files can be password protected to prevent unauthorized access to the data.
The MDB format is a powerful tool for storing and managing data, and it is widely used to create various types of applications, including accounting systems, inventory databases, order management systems and much more. |
| Technical details | An MDB file contains tables, fields, indexes, queries, forms, reports, macros and VBA modules. Tables contain records, each record corresponds to a specific data format defined in the table. Data is stored based on the table structure and relationships between them, which makes it easier to organize and MDB files are used to store and manage structured data within a Microsoft application. Allow users to create, change, delete data, run queries and reports. Ability to add macros and VBA modules to expand database functionality. Ability to set a password to protect data from unauthorized access. The size of a .mdb file is limited by the physical limitations of the file system, but typically has a limit of several gigabytes. MDB files can only be opened in Microsoft Access or some specialized DBMSs that support this format. |
