This project is read-only.

Better way to check for mapped drives


Currently a DSN is determined to reference a mapped drive using a string comparison of the path and a list of mapped drives.
A more resilient method would be to use the Scripting.FileSystemObject FileExists method to test each Registry Value to see if it refers to a file;
If so the file can be retrieved using the GetFile method;
Then the file's .Drive.DriveType property can checked to see if the drive is a mapped Network Drive
FileExists method:
GetFile method:
File object:
Drive object:
DriveType property: