Microsoft Access 2010 Bible

Chapter 24: Optimizing Access Applications

875

1. Open a new empty database.


2. Select the External Data ribbon tab.


3. Click the Access option on the Import group.


4. Select the database you’re having problems with.


5. Ensure that the Import Tables, Queries, Forms, Reports, Macros, and Modules into the
   Current Database option is selected.


6. Click OK.


7. Click on Select All for each of the relevant tabs shown in Figure 24.14.


8. Click OK.

If you have any custom menus and toolbars, import/export specifications, or Navigation Pane

groups, remember to select the appropriate items in the Import Objects dialog box (shown in

Figure 24.14). If the old database contains custom database properties, you have to create them

again because they can’t be imported.

Caution
If you use externally referenced libraries or add-ins, you must manually reference these libraries in the new
database. Choose Tools ➪ References in the VBA editor to do this. As well, you’ll need to reset any of options
specified on the Current Database tab, such as Application Title, Display Form, and so on (choose File ➪
Access Options).

FIGURE 24.14

Importing database objects (the Options button has been pressed in this case)