What I have
I've got 2 lists (listA, listB). In listA there are several lookup columns to listB.
What I want to do
I want to create a query that updates a field in all items in listA from 'empty' to '1'. The field is not a lookup.
I have to fetch listB, otherwise I get an error when I run the query. But when both lists are imported I get the following error while running the query:
"The Microsoft 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.'"
I don't understand why the number of lookups would be an issue since the query doesn't influance them. Is there any way to solve it?