Hi there,
I'm beginning to to pull my hair out with this.
My database that distribute to my team is failing to sync all columns on linked a SharePoint list
I've added a button to the database to auto re link the SharePoint to resolve this issue:
DoCmd.DeleteObject acTable, "tblPro"
DoEvents
DoCmd.TransferSharePointList _
acLinkSharePointList, _
"https://nhsengland-my.sharepoint.com/personal/blahblah/", _
"{C4ZFF04B-5FE8-4C35-AAE7-2503FC532EC0}", _
"{4254C6B8-2582-4AF5-9A93-39914A02E379}", _
"tblPro", _
True
CurrentDb.TableDefs("tblPro").RefreshLink
DoEvents
Although this links the SharePointlist it does not sync all columns, e.g. only syncs 8 out 10 columns making the data not available.
just to clarify the columns are not hidden.
The only way to fix this is to re-link it manually which is a no no...is there anyway to force access to get all columns using a procedure?
Many thanks
Max