MS access table schema refresh issue

[carahorse]

I am working with MS Access 2010 and Sharepoint 2013. I had this problem with 2010 too. I need a VBA to refresh the tables on load or the form on load, I get an error that says to the effect of" table shcema has changed you must refresh your table" and I will lose half my work on the form. Is there any way to refresh a table link to sharepoint other than using the Refresh Table Schema button in the navigation bar?:banghead:

 

[Pat Hartman]

I can't promise this will work since I don't have any apps linked to SharePoint tables, but, try using the TransferDatabase method to refresh the linked tables.

 

[carahorse]

An example would be great

 

[pr2-eugin]

How about THIS..