pane is showing. You also size the application window for your trashed database so only the
Navigation pane is showing.
Place the two windows on your screen so they sit side by side. Right-click the Navigation
pane in each database, select Category on the pop-up menu, and then select Object Type, so
all the objects are shown in type order.
Your screen should now look like Figure 37-1.
If you are fortunate enough to have a double screen on your computer, you can set each
database to each window without having to resize them.
Now that you have the two databases side by side, all you need to do now is drag and drop
all the database objects from the trashed database to the blank database. You have to do this one
at a time, which is fairly time consuming, but itisa solution to recovering your application.
Make sure you pull across all the objects—tables, queries, forms, reports, macros, and
modules. Linked tables can also be brought across in this way. Once everything has been
transferred to the new database, make sure you do a compact and repair on the new database
to make sure it is as small as possible.
You now have a fully working copy of your original database, complete with the most
recent users’ data, and your reputation has been saved!344 Microsoft Access 2010 VBA Macro Programming
Figure 37-1 Host and target databases shown