developingprogrammer
asked on
cannot change linked text file path
hi guys,
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?
thanks guys!
TextFileLInking.zip
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?
thanks guys!
TextFileLInking.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome!
/gustav
/gustav
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hey gustav i read up a bit on the 8.3 short file name on wiki and that's really cool. i'm not sure how i would ever come across this 8.3 short file name if you didn't mention it ha. haven't had time to go through the whole thing but really interesting and helpful. thanks once again!! = ))
thanks for your help Jim! in the end i resorted to the DoCmd.TransferText function cause i think linking to a textfile is less stable than importing it in - as in one fixed state to another fixed state. something like deterministic state. DFSM i think it's called - not sure if i'm using it correctly though ha. but thanks for your sharing!! = ))
thanks for your help Jim! in the end i resorted to the DoCmd.TransferText function cause i think linking to a textfile is less stable than importing it in - as in one fixed state to another fixed state. something like deterministic state. DFSM i think it's called - not sure if i'm using it correctly though ha. but thanks for your sharing!! = ))
ASKER
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 = )