Linked Tables

[David W]

Has anyone ever heard of a corrupted link?
This morning I opened a query and the data was corrupted. I opened the table
and it looked fine.
I deleted the links and relinked them and every thing was fine.
Is there a such thing as refreshing links?

 

[Allen Browne]

David, I've never seen a link corrupt, but there is a very good chance that
this is another example of a Name AutoCorrect bug.

Make sure this horrendously buggy "feature" is disabled in both the back
end, and in the front end. Then compact both so that Access completely
forgets the invalid associations it regularly makes in a query about what
fields you are talking about, and what tables they come from.

More info on other kinds of problems caused by Name AutoCorrect:
http://allenbrowne.com/bug-03.html

 

[Immanuel Sibero]

David,

It's happened to me before, but I was linking to non-Access tables. At
times, when the originating table structure is changed (i.e. new fields are
added or deleted, etc), I had to delete and reestablish the links (as you
have found out).


Immanuel Sibero