I have created an Access 2007 application based on 25 sharepoint tables. Data is linked.
Normally I see all records of all tables perfectly. The application is now running for two years.

In these two years I had two times the same problem (in nov. 2010 and now again (on different tables))

For one of the tables only the first record is displayed in ACCESS. If I look directly into the sharepoint (via webbrowser) I see all the records. I get no error messages.( I'm system administratot so a authorization issue is not the case.).
What could cause this problem and how to solve?


In trying solving this problem I relinked the sharepoint tables and yes! everything is fine again.

But this gives a bad feeling, because how do you know there is something wrong??

In prevous times when I still worked with local data, I had to relink the tables sometimes when I distributed a new front end. But in that case, if the link was not OK anymore, I got an error message. Because I did not get any error messages now I assume that relink (with coding) was not necesarry. Anyhow I distributed some new frontends. But I do not know if this has something to do with the problem.

Any help is appreciated

Willem (Holland)