Linked Table Manager Question

[MayFlowerNew]

Hi All,

I am newbee to MS Access. I have a table linked to a txt file already. Someone who has created this table has given different column names to it.
I want to create a new table with same structure as the previous one linking to a copy of the same txt file.

For example Table A is linked to txt file AA. Now the year changes, I take backup of this txt file AA, rename it as AALastYear and create a new Table say ALastYear linked to AALastYear.

If I just copy the table A and rename it to ALastYear, it shows linked to txt file AA. I dint find anyway to change it to new txt file.
Please help

Thanks

 

[MayFlowerNew]

MS Access help Topic "View, refresh, or change the file name and path for linked tables" says

"The Linked Table Manager can't refresh links to Microsoft Access tables whose names were changed after they were linked. You must delete the current link, and then link such tables again. "

So I linked the table again and manually defined the structure.

Thanks