SP form Integration to Access Database tables

Category: sharepoint 2013 - general discussions and questions

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!

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.


Lisa Chen1226 on Fri, 12 Oct 2018 11:06:38


Hi Sunvinmon, 

Is there anything update about this issue?

If the reply is helpful to you, you could mark the reply as answer.

Thanks for your understanding.

Best regards,

Lisa Chen 

Lisa Chen1226 on Fri, 12 Oct 2018 11:06:40


Hi Sunvinmon, 

Is there anything update about this issue?

If the reply is helpful to you, you could mark the reply as answer.

Thanks for your understanding.

Best regards,

Lisa Chen