Question

Sunvinmon on Fri, 05 Oct 2018 14:19:07

Hello,

i have reports utility in Access that depend on table information stored in access. The tables are populated by data entered in Access forms by end users. I would like this form to be published in SharePoint (web) instead of having the end user install Access
file on there machine. A Web option would be most preferable. Having that said, i am aware that a SP listing can be linked to Access table from SP Web but i couldn't get the synchronization working i.e if SP list or form is updated with data then the underlying
Access table should also update with new information. What am i missing to make this work? Appreciate your help!

Thank you,

Vinny!

Sponsored

Replies

Lisa Chen1226 on Mon, 08 Oct 2018 09:49:56

Hi Sunvinmon,

To sync access table with SharePoint list, you can open create a SharePoint list, click "Open with Access":

Then choose "Link to data on the SharePoint Site":

Now it will sync the SharePoint list with the access table.

Best Regards,

Lisa Chen

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact
tnmff@microsoft.com.

Click here to learn more. Visit the dedicated forum to share, explore and
talk to experts about Microsoft Teams.