Link to open text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to link a table to a text file that is always open as a service log
file. This is for read-only reporting, and I don't care if the file changes
after I open the table. I tried to link to the file, but Access refused.

How can I link to an open text file?

Thanks,
Tony Scandora
Tony at AES Systems Corp dot com
 
Hi Anthony,

I have a feeling this isn't possible and that Access requires exclusive
access to the text file it links to. One work-round would be to make a
temporary copy of the file and link to that. I don't know whether the
VBA FileCopy statement is capable of copying an open file; if not, you
can use Shell() to call XCOPY.
 
John Nurick said:
Hi Anthony,

I have a feeling this isn't possible and that Access requires exclusive
access to the text file it links to. One work-round would be to make a
temporary copy of the file and link to that. I don't know whether the
VBA FileCopy statement is capable of copying an open file;
Click to expand...

No, the file must be closed for FileCopy to work on it.
 
Back
Top