Managing Linked Access Database Tables
Linking Tables from another Access Database
Splitting an Access database into a front-end database (containing the Forms, Reports, and other User objects) and a back-end database (that holds the actual data entered into the database) is very common. This configuration is most often employed when building multi-user business applications, as it provides significant database speed and performance gains while reducing network traffic and the opportunity for user conflicts to occur in multi-user environments. Managing the linkage between the front-end and back-end databases is made easy using the Access Database built-in data linking tools
This FAQ provides a step by step guide to show how to quickly and easily link tables from external Access Databases.
Step by Step - How to Link External Access Database Tables
- Open the Access database into which tables from an external Access Database will be linked.
- Next open the 'Microsoft Access - Get External Data' panel. On the Access Database ribbon clcik the 'External Data' tab. Next select the options 'New Data Source' ⇒ 'From Database' ⇒ 'Access'. (Note the icon location for opening the 'Data Sources' panel may vary depending on your version of MS Access Database), but the process will be very similar to that outlined here.
- When the 'Get External Data - Access Database' panel opens, ensure the 'Link to the Data Source by creating a Linked Table' is ticked and then click the 'Browse' button.
- Use the Windows Explorer browser to navigate to the folder containing the database in which the table or tables to be linked is located. Double click the database name or highlight the database name and then click the 'Open' button.
- Back on the 'Get External Data - Access Database' panel opens, ensure the 'Link to the Data Source by creating a Linked Table' is still ticked and then click the 'OK' button.
- On the 'Linked tables' selector form ensure the 'Tables' tab is selected. In tables list select (highlight) the table(s) you want you front-end database to link then click the 'OK' button. Wait whilst the links are created. You can elect to add one or multiple tables but be sure to select only those table that are relevant to your needs.
- The linked tables will are displayed in the Tables section of the Database Object Pane. Note, linked tables are indicated by having a blue arrow icon beside them.
- If at any point you want to check the source of a linked table, in the Database objects pane, right click the name of the linked table and select 'Linked table Manager' from the dropdown list options. If necessary, you can use the Linked Table Manager to relink tables if the source database has been moved. To do so click the 'Always Prompt for New Location' and click the 'OK' button. You will be prompted with a browser to select the file in its new loaction.