Linking to Another Access Table
To link a table to a database, start Access and open the database to which you want to link a table. In Access 2003 or earlier, go to the File menu, point to Get External Data and click on Link Tables. If you are using Access 2007, go to the External Data tab and click on Access in the Import section.
In the Link dialog box that opens in Access 2003 or earlier, click the Browse button. Navigate to the Access file that contains the table you want to link to this database. Select it by clicking it once, and then click the Link button. If you are using Access 2007, the Get External Data dialog will open. Click Browse and select the file with the table to be linked to the database. Under Specify How and Where You Want to Store the Data in the Current Database, select Link to the Data Source by Creating a Linked Table and then click OK.
In any version of Access, a Link Tables dialog box will appear. Select the table from this database file that you want to link to the database previously opened. Click OK.
The linked database will now be listed in the window of the previously opened Access database. There will be an arrow to the left of this table, which informs you that this is a linked table.