Whenever I have had this, it's because the underlying table has changed since
I linked it.
See what happens if you use linked table manager to refresh the link, (or
maybe delete and redo it)
Aplogies if this seems trivial, but, but that's the only problem I've ever
had like this.
