ACCDB File Format

Why Trust Techopedia

What Does ACCDB File Format Mean?

The .accdb file format is the default file-saving format for Microsoft Access beginning with its 2007 version. Previous versions of Microsoft Access, created with Access 2003 and earlier versions, use the .mdb file format by default.

Advertisements

Techopedia Explains ACCDB File Format

The .accdb file format is analogous to the .docx and .xlsx formats of Microsoft Word 2007 and Excel 2007, respectively. In fact, the .accdb format is more widely known as the “Access 2007” file format. Databases created or saved as .accdb files cannot be opened by versions of Microsoft Access prior to 2007, which includes Access 95, 97, 2000 and 2003. Databases created in the earlier .mdb format can be converted to .accdb databases by simply opening them in Access 2007 or a later version and saving in the newer file format. Of course, the newer versions of Access are also fully backward-compatible with older .mdb files.

The .accdb format supports some features not available in the .mdb format, such as multivalued fields, data macros, ability to include attachments in the database, integration with Sharepoint and Outlook, and publishing to Access services. However, some older features like replication and user-level security are no longer supported in the newer format.

Advertisements

Related Terms

Margaret Rouse
Technology Expert
Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.