What is an ACCDB File?

How to Open, Edit, & Convert ACCDB Files

Picture of the ACCDB file icon

A file with the ACCDB file extension is an Access 2007/2010 Database file. It's the default format for database files in the current version of MS Access.

The ACCDB file format replaces the older MDB format used in prior versions of Access (before version 2007). It includes enhancements to it like support for encryption and file attachments.

When you're working on an ACCDB file in Microsoft Access, a similar MS Access Record-Locking Information file (with the .LACCDB extension) is automatically created in the same folder to prevent from accidentally editing the original file.

This temporary file is especially helpful when multiple people are using the same ACCDB file simultaneously.

How To Open an ACCDB File

ACCDB files can be opened with Microsoft Access (version 2007 and newer). Microsoft Excel will import ACCDB files, but that data will then have to be saved in some other spreadsheet format.

The free MDB Viewer Plus program can also open and edit ACCDB files. This is a great alternative if you don't have a copy of Microsoft Access.

Another way to open and edit ACCDB files without Access is to use OpenOffice Base or LibreOffice Base. They both let you connect to an existing Microsoft Access 2007 database (an .ACCDB file), but the result is a file saved in the ODF Database format (an .ODB file).

You can use MDBOpener.com to upload the ACCDB file online and view the tables without ever needing any database software on your computer. Though you aren't able to manipulate the database file in any way, you can download the tables in the CSV or XLS format.

ACCDB MDB Explorer for Mac can also open ACCDM and MDB files, but it's not free to use.

Note: You may need to install Microsoft Access Database Engine 2010 Redistributable if you're trying to use an ACCDB file in a program that isn't MS Access.

How To Convert an ACCDB File

Using Microsoft Access is the best way to convert an ACCDB file to another format.

You can do this by opening the ACCDB file in Access and then saving the open file to a new format like MDB, ACCDE, or ACCDT (a Microsoft Access Database Template file).

You can also use Microsoft Excel to save the ACCDB file's table to a different format, but since Excel is a spreadsheet program, you can only save to that type of format. Some of the supported formats in Excel include CSV, XLSX, XLS, and TXT.

Whether you're using Access or Excel, you can convert an ACCDB to a PDF file using a free PDF creator like doPDF.

Keep in mind what I said above about the OpenOffice and LibreOffice software. You can use those programs to convert an ACCDB to ODB.

Follow the steps at Server Side Guy if you need to import an ACCDB file in Microsoft SQL Server.

More Help With ACCDB 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 ACCDB file and I'll see what I can do to help.

More From Us