Here it is.

I have an application which creates a log file (*.txt). I have created a query in access that goes and reads this log file and populates a table with the information gotten from the .txt file. However if the query runs at the same time as the other application the file is locked and my other application can't write to the .txt file. Is there anything I can do to make the query open the .txt file in read-only therefore leaving the other application the capability of writing to it?

Thanks.



[LGuzman]

__________________
[LGuzman]