If your database contains Visual Basic for Applications (VBA) (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Windows applications and is included with several Microsoft applications.) code, you can hide that code by saving your Microsoft Office Access database (database: A collection of data related to a particular subject or purpose. Within a database, information about a particular entity, such as an employee or order, is categorized into tables, records, and fields.) in the .accde file format. Saving a database as an .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.
In this article
Create an .accde file
Use the following procedure to create an .accde file. This procedure leaves the original .accdb file unmodified.
- On the Database Tools tab, in the Database Tools group, click Make ACCDE.
- In the Save As dialog box, browse to the location where you want to save the .accde file.
- Optionally, type a new name for the file in the File name box.
- Click Save.
If a file by the name that you specify already exists, Access prompts you to replace the existing file. Click Yes to overwrite the existing .accde file, or click No to return to the Save As dialog box and type a new file name.
Access creates the .accde file, closes the original .accdb file, and then opens the .accde file.
Top of Page
Functionality that is changed in an .accde file
Saving your Access database as an .accde file does not completely prevent changes to the database design. However, the following tasks cannot be performed in an .accde file:
- Modifying or creating forms, reports, or modules.
- Using the VBA References dialog box to add, delete, or change references to object libraries or databases.
- Viewing or modifying the VBA code.
- Importing or exporting Access forms, reports, or modules. However, tables, queries, and macros can be imported from or exported to .accdb databases.
Top of Page
Issues with modifying forms, reports, or modules
Be sure to keep a copy of your original Access database. If you want to modify the design of forms, reports, or modules in an .accde file, you must modify the original Access database (the .accdb file), and then save it again as an .accde file. Saving an Access database that contains tables as an .accde file can lead to problems with reconciling different versions of the data if you later want to modify the design of the forms, reports, or modules. For this reason, saving an Access database as an .accde file is most appropriate for the front-end database of a front-end/back-end application (front-end/back-end application: A database application consisting of a "back-end" database file that contains tables, and copies of a "front-end" database file that contain all other database objects with links to the "back-end" tables.).
Top of Page
Restrictions on saving a database as an .accde file
Some restrictions can prevent you from saving your Access database as an .accde file:
If you encrypt a database with a password before you save it as an .accde file, the .accde file will also be encrypted, and you will have to enter the password every time that you open it. If you do not want the .accde file to be encrypted, you must decrypt the .accdb file before saving it as an .accde file. After you save the database as an .accde file, you can encrypt the .accdb file again. Use the following procedure to decrypt an .accdb file:
- On the Database Tools tab, in the Database Tools group, click Decrypt Database.
- In the Unset Database Password dialog box, in the Password box, type the database password.
- Click OK.
Top of Page
How references work with .accde files
If you try to create an .accde file from an Access 2007 database (.accdb) or from an Access 2007 add-in (.accda) that references another Access database or add-in, Access 2007 displays an error message and does not let you complete the operation. To save a database that references another database as an .accde file, you must save all databases in the chain of references as .accde files, starting from the first database referenced. After saving the first database as an .accde file, you must then update the reference in the next database to point to the new .accde file before saving it as an .accde file, and so on.
For example, suppose that Database1.accdb references Database2.accdb, and Database2.accdb references Database3.accda. To save Database1.accdb as an .accde file, do the following:
- Save Database3.accda as Database3.accde.
- Open Database 2.accdb, and change its reference to point to the new file named Database3.accde.
- Save Database2.accdb as Database2.accde.
- Open Database1.accdb, and change its reference to point to the new file named Database2.accde.
- Save Database1.accdb as Database1.accde.
Top of Page