Word Document (.docx) - Default format
Word Macro-enabled Document (.docm)
Word Template (.dotx)
Word Macro-enabled Document Template (.dotm)
Excel Workbook (.xlsx) - Default format
Excel Macro-enabled Workbook (.xlsm)
Excel Template (.xltx)
Excel Macro-enabled Workbook Template (.xltm)
Excel Binary Workbook (.xlsb)
Excel Add-in (.xlam)
PowerPoint Presentation (.pptx) - Default format
PowerPoint Macro-enabled Presentation (.pptm)
PowerPoint Slide Show (.ppsx)
PowerPoint Macro-enabled Slide Show (.ppsx)
PowerPoint Template (.potx)
PowerPoint Macro-enabled Presentation Template (.potm)
PowerPoint Add-in (.ppam)
This is the standard file name extension for databases (default format) in the Office Access 2007 file format. This format takes the place of the .mdb file name extension that is used in earlier versions of Access.
This is the file name extension for Office Access 2007 files that are compiled into an "execute only" file. This format takes the place of the .mde file name extension that is used in earlier versions of Access.
An .accde file is a "locked-down" version of the original .accdb file. If the .accdb file contains any Visual Basic for Applications (VBA) (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Microsoft Windows-based applications and is included with several Microsoft programs.) code, only the compiled code is included in the .accde file. As a result, the VBA code cannot be viewed or modified by the user. Also, users working with .accde files cannot make design changes to forms or reports. You create .accde files from .accdb files by doing the following:
In Office Access 2007, open the database that you want to save as an .accde file.
On the Database Tools tab, in the Database Tools group, click Make ACCDE.
In the Save As dialog box, browse to the folder in which you want to save the file, type a name for the file in the File name box, and then click Save.
This is the file name extension for Access Database Templates.
The .accdr file is a new file name extension that enables you to open a database in run-time mode. By changing a database's file name extension from .accdb to .accdr, you can create a "locked-down" version of your Office Access 2007 database. You can change the file name extension back to .accdb to restore full functionality to your database.
The workgroup information files store information for secured databases. No changes were made to the .mdw file format for Office Access 2007. The Office Access 2007 Workgroup Manager creates .mdw files that are identical to those that are created in Access 2000 through Access 2003. The .mdw files that are created in those earlier versions can be used by databases in Office Access 2007.
Note: You can use Office Access 2007 to open an earlier-version database that has been secured by using user-level security. However, user-level security does not exist in Office Access 2007 databases. There is no command on the Ribbon (part of the Microsoft Office Fluent user interface) to start the Workgroup Manager, but you can still start the Workgroup Manager in Office Access 2007 by using the DoCmd.RunCommand acCmdWorkgroupAdministrator command in VBA code, or by creating an Access macro that contains the RunCommand action with a Command argument of WorkgroupAdministrator.
When you open an Office Access 2007 database, file locking is controlled by a locking file with the file name extension .laccdb. The .laccdb file corresponds to the .ldb locking file that is created when you open an earlier version Access (.mdb) file. The type of locking file that is created depends on the file type of the database that is being opened, not which version of Access you are using. For example, if you open the file Db1.mdb, Access creates and opens a file named Db1.ldb. By contrast, if you open the file Db1.accdb, Access creates and opens a file named Db1.laccdb. Locking files are deleted automatically when all users close the database.
If separate locking files are maintained for both Office Access 2007 files and files that are created in earlier versions of Access, it is possible to have databases named Db1.mdb and Db1.accdb open in Office Access 2007 at the same time without creating any locking file conflicts. This is because two different locking files (.ldb and .laccdb) are created. Also, it is possible for one user to open an .mdb file in Office Access 2007 while another user opens the same .mdb in an earlier version of Access. In this case, both sessions use the same .ldb locking file.