Changing File Name of a Linked Table

[FBandData]

I have a file named file.txt that is linked to my Access Database. I now want to change that to file2.txt. How can I go about changing that? When I click the box to "Always Prompt Me for File Location" it will let me select file2.txt, but then it keeps it as file.txt. If I move file2.txt to another folder, it says it cannot find file.txt.

How can I change the file name from c:\mydirectorypath\file.txt to c:\mydirectorypath\file2.txt?

 

[Micron]

At first, I thought you were linking to text files (or other non-Access or Excel files) using the Text File button on the Import menu on the Get External Data tab of the ribbon but "Always Prompt Me for File Location" is not a function of that process. You must be using the Linked Table Manager. Although it looks like you can, you will only be able to pick the folder where the existing linked file is (relink), not pick a new file. Use Import > Text File on the Get External Data tab of the ribbon to choose another file.

 

[xenou]

Does seem to be easier to just replace file.txt with the new file, renaming it file.txt. As Micron reported, it's not going to work the way you want if you just pick the new file in the Table Manager.

If you do go with replacing the file with the new file, this probably requires no one be in the DB so best if it's single user. Otherwise, consider using importing data rather than linking data.