I have a database that is linking to text files. The files will be changed frequently and the problem I have run into is that the files are created on a Unix machine that is not leaving a recognizable EOF marker. I can manually open the file, put the curser to the right of the last character, hit the delete key, close the file and save changes. This corrects the problem.
Does anyone have an idea how I can automate this procedure from Access?
I'm posting the question at 75 points, but will double it if someone gives me a working solution by 9:00 AM ET Saturday.