Forum Discussion

dajohnson162000hot's avatar
dajohnson162000hot
Copper Contributor
May 28, 2020

MS Access

All of my tables are shared/linked to Sharepoint. If I add something in a table will it automatically update Sharepoint? If yes, then where do I find the lists/tables in Sharepoint? Is the link from ...
access
George Hepworth's avatar
George Hepworth
Iron Contributor
May 29, 2020

dajohnson162000hot Yes, it works the same way as a standard Access accdb FE and BE design. It's just that the BE is actually the SharePoint lists, on linked tables in a separate accdb. Plus, you get a bonus with SP lists. The synching mechanism for SP lists is quite good, meaning one or more users can disconnect from the internet and continue working locally with the Access accdb with a high level of confidence they can reconnect and re-synch to the SP list changes that occurred in the interim. There's a significant amount of manual intervention involved, but it's reliable.

dajohnson162000hot's avatar
dajohnson162000hot
Copper Contributor
Jun 03, 2020

George Hepworth Thanks George for your response. How do I find the "Sync" button in Access? Also, I am assuming that if I make any changes to the Front End I will need to have all the users download the revised ACC file to their machines again. Is that correct? 

 

Resources