Due to a certain problem on our network, our IT guy instructed us to use the following in a batch file every time we restart the pc's,
route add XXX.XXX.1.XXX mask 255.255.255.255 XXX.2.1.1
this should make the folder on the server where our Access DB resides should be recognized
However the folder does not get to accessible until we open the windows browser and double click on that mapped network drive (N:).
Now I wonder if there is a way to avoid that extra last step?
It could be either by adding something to the batch file, or perhaps adding some code in our Access FE application that would accomplish that.
FYI- Only Win7 users are required to run that batch & need to have this fixed, while Win XP users are not required, and the network drive is immediately recognized upon restart.