• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 18. Sharing Data with Other Applica... > Linking to Tables in Another Access ...

Linking to Tables in Another Access Database

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:

1.
Open the database that will contain the link.

2.
Right-click within the Database window and choose Link Tables from the context menu.

3.
Navigate to the folder that contains the source database.

4.
Double-click the source database. The Link Tables dialog box appears (see Figure 18.9).

Figure 18.9. The Link Tables dialog box.


5.
Select the table(s) you want to link to.

6.
Click OK. Figure 18.10 shows the results of such an operation.

Figure 18.10. The linked tables with an arrow that indicates that they are linked.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint