Access Database with Linked Table to SharePoint (1 Viewer)

[sandanet]

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?

 

[theDBguy]

You could try:

DoCmd.RunCommand acCmdRefreshSharePointList

 

[sandanet]

thank u Mr. @theDBguy I'll try it

 

[theDBguy]

thank u Mr. @theDBguy I'll try it

Let us know how it goes...

 

[sandanet]

Let us know how it goes...

Unfortunately, the data is not updated immediately but rather takes a long period of time

I found the same problem posed here

Auto refresh Sharepoint-linked Tables in Access 2010?

I have two tables linked with sharepoint lists. And I have a form in access db, each time when the form loads the table which is linked to sharepoint list should refresh automatically. Is there ...

stackoverflow.com

So I'm ganna use both of mentioned codes