Link to open text file

  • Thread starter Anthony E. Scandora, Jr.
  • Start date
A

Anthony E. Scandora, Jr.

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
 
J

John Nurick

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.
 
K

Ken Snell \(MVP\)

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.
 
Top