Database Location change

[Srin]

I use Access 2013, and have an Access Database in which one of my Tables is linked to a SharePoint site (SharePoint 2010).
The database is in my computer, but I will be required to shift it into another computer onto a network drive. I want to know if doing this will affect the table's link or data exchange between the table and its linked list on SharePoint

[JoeM]

You can use the Linked Table Manager in Access to re-point those linked tables to new/different places on your computer or network.

[Srin]

Hi JoeM,

Thank you for the reply. I also want to know if I am using queries to update the linked table from another table on the database, will they get affected too after moving to another location.

[JoeM]

I also want to know if I am using queries to update the linked table from another table on the database, will they get affected too after moving to another location.

Linked tables are not copies of the data table, but a real-time view of them. Linked tables look directly at whatever they are linked to. So if you update the table that they are looking at, whether it be from another query, database or whatever, those changes will be evident in that linked table.

[Srin]

Thank you for helping me understand this.

[bamia]

Sorry, wrong thread.