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)