1

I have an Access database linked to a Sharepoint list. Users will often work on the Access database offline, and catch changes locally. When online again, the user has to manually click reconnect to tables as showing below:

enter image description here

Then manually click the synchronize ribbon as showing below:

[enter image description here}2

I am thinking about using VBA to automate these 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, since Access is a good offline front-end solution for a server database. But I have searched for hours and still found nothing relevant. Can anyone help me with this?

0

You must log in to answer this question.

Browse other questions tagged .