Phantom Network Drives

Here's something I use to help simulate the client's environment, while working dis-connected from their network.

If the client's server (no pun intended) is mapped to drive S:, on my "unplugged" machine I will create a folder C:\DriveS and then in my AUTOEXEC.BAT file, add the statement SUBST S: C:\DriveS which creates a phantom drive S:.

If the database back-end is on drive S: this works; if it is mapped to a UNC drive designation it does not.