MS Access 2016 auto-sync with sharepoint list after restore internet connection

Pepin Peng
Pepin Peng used Ask the Experts™
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 1picture 1: reconnect tables :

then manually click the synchronize ribbon in picture 2picture 2: synchronize:

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.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Walter CurtisSharePoint AED
Distinguished Expert 2018

You can work offline and sync SharePoint list through Outlook and a lot of what you are looking to do is done for you.

Just a thought...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial