SharePoint Lists, MS Access and the 5000 record limit.
So I am very familiar with the 5000 list limit with SharePoint. And my SP admin will not increase that threshold. I understand because of the performance.
But here is the issue I am facing and it's odd.
So I have two list in SharePoint. tbl_Parent_Inventory and tbl_Child_Inventory. They were created in Access first, with a one to many relationship from the Parent to Child. Then upsized to SP. I reached the 5000 limit with the parent table and it would not allow changes in the child inventory. Which has not reached the 5000 limit.
I also have one other list, tblAuditTrail. This list holds all the actions that have been performed on all the forms. There is 24,000 records there. I have no issue viewing these records in Access. All 24,000 show up. I can make changes to them and I can add more. I can see all the records in the other two tables. But I can not make changes.
So my thinking is the relationship between the two tables is the issue. But I am not sure. Has anyone else encountered this before and if so how did you overcome it.