What format is used to save a locked version of a database?

The locked version of a Microsoft Access database is saved in the ACCDE format. This format is essentially a compiled version of an ACCDB database. When a database is converted to ACCDE, the VBA (Visual Basic for Applications) code and queries are locked, which prevents users from modifying the design, ensuring that the database’s functionality remains consistent and secure.

Using ACCDE is particularly beneficial in situations where you want to distribute a database to users while preventing them from altering critical components that could lead to errors or security vulnerabilities. This makes it a preferred choice for finished applications as it retains user-friendly features while safeguarding the underlying database structure.

In contrast, other formats like ACCDB and MDB do not provide this protection. ACCDB is the standard format for newer databases and allows full editing capabilities, while MDB is the older format used in earlier versions of Access, which also does not lock the design. DBASE is not related to Access formats, as it pertains to a different database management system altogether.