Microsoft Office Tutorials and References
In Depth Information
Locking Up Your Database As an .accde File
✦ All VBA procedures are compiled — converted from human-readable
code (more or less readable, anyway) to a format that only the
computer understands. This change prevents a database user from reading
or changing your VBA code. (See Book VIII for information on writing
✦ No one can create forms or reports or modify the existing ones, or even
open them in Design or Layout view. No one can import any forms or
Be sure to keep a copy of your original .accdb file! If you need to make
changes in your VBA code, forms, or reports (or create new ones), you need
to use the .accdb file, not the .accde file. Most commonly, .accde files are
used for the front-end database when you split an application into two
databases (front end and back end), as we describe in Chapter 2 of this minibook.
Creating an .accde file
Saving your .accdb file as an .accde file is easy. Follow these steps:
1. Make sure that your database is in Access 2007–2013 file format by
opening the database.
Look at the title bar of the Access window. If the title bar says anything
but (Access 2007-2013 file format), you need to convert it to the
latest file format. (See Chapter 1 of this minibook for directions.)
2. Click the File tab on the Ribbon, choose Save As, click Save Database
As, and double-click Make ACCDE.
Access closes the database to do the conversion. Then you see the Save
As dialog box.
3. Specify the folder and filename for the file.
4. Click the Save button.
Access creates the new .accde file while leaving the original .accdb
file untouched. Then the new .accde file opens.
If Access runs into a problem while making the .accde file, a message box
appears, with a Show Help button. Click the button to find out what’s wrong.
Making updates later
Eventually, you’re going to want to make a new report or fix an annoying
typo in a form. You have to go back to your .accdb file to make these kinds
of changes because you can’t make changes in an .accde file.
If the .accde file is a front-end file, with no data stored in it, you can just
make your changes in the original .accdb file and resave it as an .accde
file. Because all your data lives in the back-end database, you’re all set. (If
you’re wondering what we’re talking about, see Chapter 2 of this minibook.)