Q:

Why is the Microsoft Access Linked Table Manager not updating a linked *text* file to different file name?

In Microsoft Access 2010 I am attempting to change a linked text file to point to a similar file with a different file name. However, after relinking to the new file, I discovered that my linked table was still pointing to the original text file.
Here are the steps I was taking:

I open the Linked Table Manager, then browse to the new file name...

After selecting the new file, I receive the following message that everything is good to go!

However the linked table is still pointing to the old file!
Am I doing something wrong here? Or is it expected that this would work differently for text files, and require deleting and recreating the linked table?
In VBA I can automate the relink, but it just seems odd that the wizard would not function consistently between different types of linked tables. (For example, I can use this same process to change the link to an Excel worksheet in a different file, and it relinks just fine to the new file.)

A:

I think you should compare this with other linked tables (MS Access of MS SQL Server). What you can choose using the Linked Table Manager isn't another table but another database, the table names must be the same. Linked text files must be seen as tables, their containing folder must be seen as the database.

