doCmd.transfertext hangs for minutes when accessing file on network drive

[Jai_c6]

I have some VB code that calls doCmd.transfertext to populate a table and when the text file is on the local C drive it’s instant but if I move the file to a network drive mounted by windows it hangs for a minute. This text file is only small and the behaviour is weird as hell. If I start copying a separate file of 800mb from the network drive it transfers at a reasonable rate however when MS access runs the command above to read the text files the copy speed of the other transfer drops significantly while that call hangs for a minute and then as soon as it is finished it picks up again. Something weird is going on and it has to be something to do with windows 10 or office. Note that when not running the command above windows reads and writes to the network drive very fast.

[orange]

Check the Similar Threads at bottom of the page for info.

[Gicu]

I know it is not a fix, but you could try to add code to copy the file to your local drive, import it with TransferText then delete it afterwards.

Cheers,

[Jai_c6]

None of the similar threads relate to this issue