Determine if text file is open

[orna]

Hi

I'm using TransferText to import from text file to Access,
the problem starts when it happens the moment the text file
is opened for writing by another system, in this case the
Access closed down with error.
How can i determine if the text file is open?

TIA

 

[psemianonymous]

You can use any of the file routines VBA provides, or you can use the FileSystem object...

Basically attempt to open the text file and trap for errors. If there is an error, then the file is locked.

That's simplistic, I know, but it's basically what you have to do.

 

[orna]

Thanks pseale!