We often want to link Access with external databases.

We can do this to help manage multiple research projects on the same database:

This is also useful if we are sharing a common database hosted on a server.

  1. In the External Data tab click on the desired database type in the Import & Link section
  2. Navigate to the database you want to connect to
  3. If you only want to link to the database choose Link to the data source by creating a linked table
  4. Click OK
  5. Select the tables you want to link to and click OK
  6. The arrow next to the table indicate that it is a linked table