Re: Linked SharePoint table missing data.
Strange. I have used linked SharePoint lists in the past, with over 75k records, and have not experienced anything like this.
Have you tried converting the list to a local table, deleting the list, exporting the local table back to your SP site and then re-linking?
...see, what had happened was...