Link Access DB table to Sharepoint table and sync changes

Question

I have a large access Database that I am in the process of converting. I am trying to convert replicate tables to Sharepoint Lists currently for ease of access.

For example - I have tried selecting the individual table and selecting "Link to Sharepoint Table" - this will sync the contents of the table one time to the sharepoint list. How can I make this ALWAYS sync changes to the table in access to sharepoint list?

I have also tried the "Move and Link Feature" with similar results.

I am aware that if I enter the data directly into the Linked table in the database it will populate to sharepoint however for relational limitations I need these to separate currently.

In this example If I type into the top table it does not replicate to the sharepoint list (The linked table below) - If I type into the linked table below it will replicate to the sharepoint list. How can I keep these as 2 tables while replicating the data?

Answer 1

Hi @David Strausser
Yes, you could ALWAYS sync changes to the table in access to sharepoint list using the linked table below. The two tables in your screenshot will not interfere each other.

I could not get clearly what's the "keep these as 2 tables while replicating the data" meaning, do you want to keep the two tables same?

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.