When you link to data in another database, the data remains in its source location. Access simply creates a pointer to the data. To practice linking to data in different types of databases, follow these steps:
Open the database that will contain the link.
Right-click within the Database window and choose Link Tables from the context menu.
Navigate to the folder that contains the source database.
Double-click the source database. The Link Tables dialog box appears (see Figure 18.9).
Select the table(s) you want to link to.
Click OK. Figure 18.10 shows the results of such an operation.
There are some very important things that you must remember when working with linked tables in another Access database: