What Is an MDB File?

How to Open, Edit, and Convert MDB Files

MDB Files
MDB Files.
Was this page helpful?

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/STAT.

Note: There are several other file extensions that are similar in spelling to ".MDB" but that doesn't necessary mean that their formats are similar. If your file won't open after trying the programs or websites from above, see the section at the bottom of this page for more information.

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.

Still Can't Open Your File?

Similar-sounding file extensions or suffixes that simply look the same, don't necessitate that their formats are in any way related. What this means is that you most likely can not open them with the MDB file openers or converters mentioned above.

For example, although they might sound the same, MDB files have little to do with MD, MDF (Media Disc Image), MDL (MathWorks Simulink Model), or MDMP (Windows Minidump) files. If you double-check the file extension of your file and realize that you're not actually dealing with a Microsoft Access Database file, then research the file extension you do have to learn more about the programs that might be able to open or convert that particular kind of file.

Are you sure that you do in fact have an MDB file but it's still not opening or converting with our suggestions above? 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.