I am using OpenRowSet(bulk) as a view accessing a text file. If the text file is closed I am having no problems accessing the view and retrieving the data from the text file, however, if the file has been left open I get the following error messge.
"Error Message: Cannot bulk load because the file 'Full Path & File Name' could not be opened. Operating system error code5(error not found)."
Is there any way that I can force OpenRowSet to read the file ignoring the fact that it is open. I realise that if the file has been changed and not saved then I will not get those changes.