i've a linked textfile in my database and i'm trying to change this link path to the new text files that are generated every day.
here is my database and the 2 text files attached.
i have some code for this but when it wasn't working, i tried reducing everything back to basics - e.g. not using code by relinking the text file by hand.
when i tried to relink the text file by going to the link manager, i realised even though i chose the other text file i could not relink it.
question --> 1) can linked text files have their paths changed?
2) how can i do this in code? e.g. if i can't just simply change the path, how can i create a linked text file through vba?
the short name probably also explains the error 3011 that arises when I have multiple .s in my file name when I use transfertexf. What fantastic gustav, thanks so much for your help = )