R
Rod
I have an Access vba applications that picks up a small text file from
across a local network. If the user is not connected to the network I want
to do something else.
The trouble is that if I try and get the file, or even just check that it is
there by using FileSystemObjects the user's computer spends a long time
trying to access the network, when it fails I can catch the error. However
by then the user has got bored and probably assumed the program has crashed.
Is there a way in VBA of quickly detecting if you are connected to the
network, of if a particular network drive is available.
Thanks in advance.
Rod
across a local network. If the user is not connected to the network I want
to do something else.
The trouble is that if I try and get the file, or even just check that it is
there by using FileSystemObjects the user's computer spends a long time
trying to access the network, when it fails I can catch the error. However
by then the user has got bored and probably assumed the program has crashed.
Is there a way in VBA of quickly detecting if you are connected to the
network, of if a particular network drive is available.
Thanks in advance.
Rod