I have an Access front end with a linked table to SharePoint.
There are only 3 Fields.
Number
Name
REV
Everything is fine for the first 4,500 records. But for some reason, the last few 100 are missing the Number. Its so weird. The items are on SharePoint.
If instead of creating a linked table, I have it create a local table, all of the data is there.
Also the REV field for the whole thing is off. Instead of "A B or C" its placing a number string that I cant seem to figure out where its pulling from. "649587" Just random numbers.
But again, if I make a local copy, all of the data in the REV field is correct.
Anyone have any clue as to what's going on here?
There are only 3 Fields.
Number
Name
REV
Everything is fine for the first 4,500 records. But for some reason, the last few 100 are missing the Number. Its so weird. The items are on SharePoint.
If instead of creating a linked table, I have it create a local table, all of the data is there.
Also the REV field for the whole thing is off. Instead of "A B or C" its placing a number string that I cant seem to figure out where its pulling from. "649587" Just random numbers.
But again, if I make a local copy, all of the data in the REV field is correct.
Anyone have any clue as to what's going on here?