FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -accdb file format extension has been used for a proprietary file format, developed by Microsoft and used as the default format for Microsoft Access versions from Access 2007 through Access 2016 (current version as of May 2017).

Detailed explanation-2: -A file with the ACCDB file extension is an Access 2007/2010 Database file. It’s the default format for database files used in the current version of MS Access. This format replaces the older MDB format used in prior versions of Access (before version 2007).

Detailed explanation-3: -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 .

Detailed explanation-4: -ACCDB provides better integration with SharePoint and Outlook when compared to MDB. Unlike MDB, ACCDB allows the use of multi-valued fields, making it easier to store multiple choices in the same field. ACCDB provides improved encryption of database contents compared to MDB.

Detailed explanation-5: -accde file compiles all VBA code modules, removes all editable source code, and compacts the destination database. Your VBA code retains its functionality, but the code cannot be viewed or edited. In general, the database will continue to function as usual-you can still update data and run reports.