Auto refresh Sharepoint-linked Tables in Access 2010?

ms-access sharepoint vba ms-access-2010
vuyy1182 picture vuyy1182 · May 2, 2014 · Viewed 9.8k times · Source

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

Answer

MP24 picture MP24 · May 8, 2014

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

Related questions

Data update error with SharePoint 2010 and MS Access 2010

I've encountered a strange error when attempting to update a SharePoint 2010 list that I have linked to via Microsoft Access 2010. Error: Data cannot be inserted because there is no matching record. This occurs in 2 scenarios: I attempt to run any …

Read More
How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want …

Read More
How to SUM two fields within an SQL query

I need to get the total of two fields which are within the same row and input that number in a field at the end of that same row. This is my code. Sum(tbl1.fld1 + tbl1.fld2) AS [Total] …

Read More