Linked table in Access does not show the records

Niebotel · Nov 11, 2010

In my local application built in Access 2007 are linked tables to tables on a sharepoint. This worked fine for a year now, but now a problem did pop up:
If I create new records of course you see them in both the application ACCESS and on the sharepoint.
But now I have the situation that records which were created yesterday are not displayed anymore in my application (Isee the table but it has only one record). So I see only one record. Looking directly into the sharepoint I see all the records. No error messages!
Any idea what happened????

DougP · Nov 15, 2010

try this:
in Access delete the linked table and then re-link it.

DougP

Niebotel · Nov 15, 2010

Hi DougP, I already did and that did help. But I would like to know what caused the problem. Users work on runtime versions and they are not able to solve the problem. What I did now was relink and distribute a new runtime version. But that should not be nessacary; I think.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Linked table in Access does not show the records

Niebotel

Programmer

DougP

MIS

Niebotel

Programmer

Similar threads

Part and Inventory Search

Sponsor