Pepin Peng
asked on
MS Access 2016 auto-sync with sharepoint list after restore internet connection
I have an MS Access 2016 Database linked to a SharePoint list , users will many times work on the access database offline thus catch changes locally, when online again, user has to manually click reconnect to tables as showing in picture 1 :
then manually click the synchronize ribbon in picture 2:
I am thinking use VBA to automate this two manual steps, for instance, auto-connect tables and sync database on open, or similar solutions, i thought this would be straightforward because many users need this as Access is a good offline front-end solution for server database, however I have not got any useful information on internet yet.
then manually click the synchronize ribbon in picture 2:
I am thinking use VBA to automate this two manual steps, for instance, auto-connect tables and sync database on open, or similar solutions, i thought this would be straightforward because many users need this as Access is a good offline front-end solution for server database, however I have not got any useful information on internet yet.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Just a thought...