Once you have learn how important it is to split your Access database into application and data you will need become very good at managing your linked tables. This is important if you want to be able to switch to a different back end. You will also need to manage your linked tables if you have move your current back end to new location. When you move your back end or want to switch to a different back end you must tell access when to find the back end you want to use. As, Access doesn’t automatically locate the back end for you. When you create a linked table access stores the full path to back end database for each table. When you need to switch to a different back end location you must do one of the following.
You can use the linked table manager when the source is an Access database that has been moved to a different location. You can also use it when the source table definition changes in SQL Server or another system. in order to know how this is to be done this tutorial will surely help you in learning that how use the linked table manager in Access 2016.
If you have a linked table to a SQL server database and there is a structural change to that table at the SQL server end, you will need to update your linked tables to see the changes.
At very first a new column named Biography has been added to the table name Artists in SQL Server. So now in the step we will switch over to the access database and update the linked table.
After adding the column this table was opened in SQL server but you can see that the new column is nowhere to be seen. So make a Right click on a Linked Table and select Linked Table Manager.
Choose the table you want to update and click OK.
After updating the linked table an update message will appear on your system screen. Click OK to close the message.
After then click Close to close the Linked table manager.
If the linked table is previously opened then close it and again reopen it. Now the changes will be visible in the linked table.
