External data on sharepoint is not visible in ACCESS untill I Relinked 1

[Niebotel]

In my ACCESS 2007 application I have exported all tables to a sharepoint. This works fine for 2 years now.
The frontends are installed with 6 users (local on there PC's) and they are using the same data on the sharepoint.

For 1 of the tables we run into a problem. Records which were added (in ACCESS application) were not visible anymore after logging off and logging on again.

If I look directly to the table on the sharepoint the records are there, but in ACCEsS we see only the situation before adding the records (in fact 1 old record).

To try to find a solution for this problem I relinked all tables and the problem seems to be solved.

But I would like to understand why and prevent this for happening again, because no nessages indicate something is wrong so the end-user has to see the problem!

 

[MajP]

So if I get the chance I will see if I can write the code to delete a link and relink. However, is there a way to test if the link is "bad"? Do you get a specific error message if trying to access that "broken" table.
Ideally you would want to check all your tables and only delete/relink the non functioning links.

 

[Niebotel]

no, there is not any error message. just missing data. So i have to run the relink if i miss data or every day i log on.
i look forward for your solution.
many thanks on forehand.
Willem