What Is an MDB File?

How to Open, Edit, and Convert MDB Files

MDB Files
MDB Files.

A file with the MDB file extension is a Microsoft Access Database file that literally stands for Microsoft Database. This is the default database file format used in MS Access 2003 and earlier, while newer versions of Access use the ACCDB format.

MDB files contain database queries, tables, and more that can be used to link to and store data from other files, like XML and HTML, and applications, like Excel and SharePoint.

An LDB file is sometimes seen in the same folder as an MDB file. It's an Access lock file that's temporarily stored alongside a shared database.

Note: Though they have nothing to do with Microsoft Access Database files as described on this page, MDB is also an abbreviation for a multidrop bus, Memory-Mapped Database, and Modular Debugger.

How to Open an MDB File

MDB files can be opened with Microsoft Access and probably some other database programs as well. Microsoft Excel will import MDB files, but that data will then have to be saved in some other spreadsheet format.

Another option for viewing, but not editing MDB files is to use MDBopener.com. You don't have to download this program to use it since it works through your web browser. It even lets you export the tables to CSV or XLS.

RIA-Media Viewer can also open, but not edit, MDB files and others like DBF, PDF, and XML.

You can also open and edit MDB files without Microsoft Access using the free MDB Viewer Plus program.

Access doesn't even need to be installed on your computer in order to use this program.

For macOS, there is MDB Viewer (not free, but there is a trial) that lets you view and export tables. It doesn't, however, support queries or forms, nor does it edit databases.

Some other programs that may work with MDB files include Microsoft's Visual Studio, OpenOffice's Base, Wolfram's Mathematica, Kexi, and SAS Institute's SAS.

Note: There are several other file extensions that are similar to MDB but that doesn't necessary mean that their formats are similar, meaning you most likely can not open them with the programs mentioned above. MD, MDF, MDL, and MDMP are some examples.

How to Convert an MDB File

If you're running Microsoft Access 2007 or newer (2010, 2013, or 2016), then the best way to convert an MDB file is to first open it and then save the open file to another format. Microsoft has step-by-step instructions for converting a database to the ACCDB format.

Though it's limited to converting only the first 20 rows of the table, MDB Converter is able to convert MDB to CSV, TXT, or XML.

Like I mentioned above, you can import an MDB file in Microsoft Excel and then save that information to a spreadsheet format. Another way you can convert MDB to Excel formats like XLSX and XLS is with WhiteTown's MDB to XLS Converter.

You can try this free Access To MySQL tool if you want to convert MDB to MySQL.

More Help With MDB Files

See Get More Help for information about contacting me on social networks or via email, posting on tech support forums, and more. Let me know what kinds of problems you're having with opening or using the MDB file and I'll see what I can do to help.