Microsoft Office Tutorials and References
In Depth Information
Locking Up Your Database As an .accde File
If your .accde file contains tables full of valuable information, however, you
can’t just abandon it. If you use the .accde file for data entry and editing,
that file contains your up-to-date tables. The original .accdb file has
editable forms, reports, and VBA code, but it doesn’t have the latest version of
the data stored in your tables.
No problem. Follow these steps:
1. Rename your .accde file as a backup file.
You could add today’s date to the end of the filename (right before the
.accde part). You’re about to create a new .accde file, but you don’t
want to lose the data in this file.
2. Open the original .accdb file.
3. Make any changes you want in the forms, reports, and VBA code.
If you plan to make drastic changes, make a backup copy of the .accdb
4. Save this database as an .accde file with the name that your .accde
file originally had.
5. Click the File tab of the Ribbon, choose Save As, click Save Database
As, and double-click Make ACCDE.
Now you have an updated .accde file with new, improved forms, reports,
and VBA procedures with old data. You also have an updated .accdb
file with your new, improved forms, reports, and VBA code with out-of-
6. Delete all the tables from this new .accde file.
Deleting tables sounds dangerous, but you have all these tables stored
safely in your original .accde file.
7. Import the tables from the old .accde file to the new one.
Click Access in the Import & Link group on the External Data tab of the
Ribbon, and choose the name you gave your old .accde file in Step 1.
You see the Import Objects dialog box, with tabs for tables, queries,
forms, reports, and other objects.
8. On the Tables tab, click the Select All button and then click OK.
Access imports your tables from the original .accde file to the new
.accde file, replacing the obsolete data in the tables with the current
9. Import any queries or macros from the old .accde database that you
created or changed.
Repeat Steps 7 and 8, but use the Queries and Macros tabs on the
Import Objects dialog box to import whatever changed.