I have a strange issue that appears not to have come up for anyone before (after MUCH searching online), although I hope to proven wrong :)
I have a list that uses an Info Path 2010 form to collect data from assorted users. It has been working fine for quite a while until recently when a user reported that their entries were missing. Sure enough, when I checked, the ID's they gave me were indeed missing, from ALL available views. I have created new views with no conditions/filters, and still nothing. I have created a view for these items specifically, and still nothing.
The user knew the ID's of the items they raised, so I tried going directly to the items via URL (replacing the ID= portion) and it worked, so the item DOES exist... I also imported the list to MS Access and again the item is there. So it seems to be a SP specific issue.
Any ideas? I am conscious that this only the case for items created by this one user, but I can't find any reason why that would matter when you consider they have the same list level access as everyone else, in addition to the fact that the items are missing across all views (so it's 99% sure not a filtering issue).
Can SP list items get corrupted? If so, would they be available via direct URL / via MS Access import?
Using SP 2010