When I run a query, I get the following error:
“Error: The Miscrosoft Access database engine encountered an error while communicating with SharePoint.
More detailed information: ‘The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.’
Main reason seem to be the workflows. Before the workflows, everything was ok, after putting 2 workflows on 1 contenttype: error.
There is no way to limit the number of lookup columns back to 8 (of 12), since the system self makes a lot of columns as well, and we do need the additional info in the additional columns. And as I’ve said befor, befor the workflows everything was ok.
Anyone any ideas how to solve this?
PS: SharePoint online/O365/SharePoint Designer
