In my VB App or inside a VBA code how can I refreshing the table link to an extrernal text file without receiving the error:

Runtime Error '3625': The text file specification 'xxx' does not exist. You can't import, export, or link using the specification.

Obviously the DSName ("ARTC") specified in the CONNECT string exists in the MDB because I've just used it to link the old text file that now doesen't exists in the same path.

Following you can find a code example:

Dim ArtcDB As Dao.Database
Set ArtcDB = OpenDatabase("Var.mdb")
ArtcDB.TableDefs("ARTC").Connect="Text;DSN=ARTC;FM T=Fixed;HDR=NO;DATABASE=" & PathTmp