Hi,
There is a .txt file that I regularly need to import into an Access database using the Access transfertext function. This same .txt file is a shared file that can be opened by others. I am having an intermittent problem importing the file into Access: sometimes I get Error #3051 (already opened exclusively by another user).
I have found through experimentation that if someone opens the file from Excel, during the time that Excel is going through the txt import wizard, no one else seems to be able to open the file at all. And after the import wizard completes, others can open the file through Excel or NOtepad, but as long as Excel has it open, I can't import the file into Access.
So.... how can I set up this txt file so that others can't lock Access out of it when they open it using Excel?
There is a .txt file that I regularly need to import into an Access database using the Access transfertext function. This same .txt file is a shared file that can be opened by others. I am having an intermittent problem importing the file into Access: sometimes I get Error #3051 (already opened exclusively by another user).
I have found through experimentation that if someone opens the file from Excel, during the time that Excel is going through the txt import wizard, no one else seems to be able to open the file at all. And after the import wizard completes, others can open the file through Excel or NOtepad, but as long as Excel has it open, I can't import the file into Access.
So.... how can I set up this txt file so that others can't lock Access out of it when they open it using Excel?