Vba – Auto refresh Sharepoint-linked Tables in Access 2010

ms-accessms-access-2010sharepointvba

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 ant way to do this in vba code?
I'm using

 Application.DoCmd.TransferSharePointList acLinkSharePointList

Best Answer

Use CurrentDb.TableDefs("TableName").RefreshLink (replace TableName with your actual table name).

Related Solutions

Powershell – Refresh Sharepoint-linked Table in Access

You're loading the Powershell variable with a text string which is the name of an Access constant it doesn't know about. Try it with the constant's value instead:

$acCmd = 626
$app.DoCmd.RunCommand($accCmd)

Best Answer

Related Solutions

Powershell – Refresh Sharepoint-linked Table in Access

Related Topic