Updating Links

[Shirley]

I have set up a macro that delete the old information and Transfer Text with a link and Append to the table. But when the data changes in the link, how do I update the Link. I could use On Update on the Append Query, but isn't there a faster way.

 

[elizabeth]

The link points to a table's location. So you don't need to update the link when the table's *data* changes, only when the tables's *location* (path) changes.