Hi all,
I have an MS-Access database where one of the tables is linked to SharePoint. This MS-Access database is always opened on a public computer and I use another computer to insert data to the SharePoint.
Any updates to the SharePoint data is suppose to be automatically updated to the MS-Access linked table (and vise versa) even when Access database is still opened, ain't it?
When a change is made to the data in Access, the change shows up right away in SharePoint. But if the change is done from SharePoint, I have to re-open Access to see the changes and get last updates.
Is there any code can by used in Access that will make the updates happen automatically?
I have an MS-Access database where one of the tables is linked to SharePoint. This MS-Access database is always opened on a public computer and I use another computer to insert data to the SharePoint.
Any updates to the SharePoint data is suppose to be automatically updated to the MS-Access linked table (and vise versa) even when Access database is still opened, ain't it?
When a change is made to the data in Access, the change shows up right away in SharePoint. But if the change is done from SharePoint, I have to re-open Access to see the changes and get last updates.
Is there any code can by used in Access that will make the updates happen automatically?
Last edited: