instead using disk drives, try to connect the drives to a network share.
right click on the drive and click "properties".
in the popout dialog there must be a "sharing" tab.
there you can give the "share" a name and security rights (if the disk drive has the ntfs format - fat32 dont work).
then you can create a "network drive" or "network share" that points to:
\\DESKTOP\share
\\DESKTOP is then the Server (local (host) - or: 127.0.0.1 - or: 192.168.0.0)
\share is then the Name to the sharing folder/drive
In your Applications, you can then use this share.
This are the pros.
The cons are:
if you plug off the usb drive, it is not guranteed that the drive Letter (G:) is used in the future.
Because USB dynamically gets free drive letters from System.
But (I don't know the exact procedure/process) you should be able to create a VB script or PowerShell script (with elevated rights policy) which can handle the disk drives connected to your System.
I don't know the exact name of this Windows Application, but it shall sounded like "Disk Management".
A Tool where you can set Path to your Volumes.
Use this Tool with caution !!!
Because you can easily format your connected drives/volumes if you have admin rights.
All data will be lost on the format command/menu item action !