Need a solution to deal with different drive mappings

Hello,
I am writting a progam for our company. Our company consists of 5 different
offices, each with there own servers and drive mapping. I've setup the
support folder for my program on each server with the same directory
structure, but I am forced to use different drive mappings. Currently I have
a variable called "drive" set as a constant that I use to concatenate the
directory. But each time I make a modification and copy it out to the other
offices I have to open each project and change the value of "drive". The
drive mappings vary from P: ,L :,I: , and F:.

For a solution, I was thinking of something like;

Public Drive as string

Sub FindDrive()
if file exists DIR("P:/blah/blah/project.dvb") then drive = ("p:\")
if file exists DIR("F:/blah/blah/project.dvb") then drive = ("f:\")
etc.
etc.

End Sub

Would that work, and if so is it a good solution?

Thanks,
Eugene

 

What about creating a system variable (os, not acad) called "AcadDrive" or something similar, setting its value to the local mapping? Then, your code can concatenate the sysvar with the standard portion of your path.

--
----
Ed
----
Hello,
I am writting a progam for our company. Our company consists of 5 different
offices, each with there own servers and drive mapping. I've setup the
support folder for my program on each server with the same directory
structure, but I am forced to use different drive mappings. Currently I have
a variable called "drive" set as a constant that I use to concatenate the
directory. But each time I make a modification and copy it out to the other
offices I have to open each project and change the value of "drive". The
drive mappings vary from P: ,L :,I: , and F:.

For a solution, I was thinking of something like;

Public Drive as string

Sub FindDrive()
if file exists DIR("P:/blah/blah/project.dvb") then drive = ("p:\")
if file exists DIR("F:/blah/blah/project.dvb") then drive = ("f:\")
etc.
etc.

End Sub

Would that work, and if so is it a good solution?

Thanks,
Eugene

 

You might think about using UNC paths unless you can be certain that the
drive mapping is consistent and unchangeable.

 

UNC won't work unless the servers are the same name, and if they are, the IT
guys should be shot.

Ed's is the easiest approach. There might be programmic relief under VB
Script's network object.

--
R. Robert Bell


You might think about using UNC paths unless you can be certain that the
drive mapping is consistent and unchangeable.

 

Not sure I fully understand your situation, but would any of these help?
[pre]
AcadApplication.Path
Preferences.Files.SupportPath
AcadApplication.VBE.ActiveVBProject.FileName
[/pre]
Regards

Wayne Ivory
IT Analyst Programmer
Wespine Industries Pty Ltd

 

That's likely going to be your best/simplest approach - always assuming that
the file path is always the same.

You could even take it one step further so that you never have keep adding
lines and just run a loop from A-Z. Ideally making this a sub routine that
you can just run at the beginning load of your utilities. This way if
another office opens and decides to use another letter. Just a thought.

 

I was thinking in terms of having a list of server names to test against
instead of mapped drives.
Users can change their drive mappings but only IT can change server names.
New machines may not have any mapping but the servers will exist.
That makes UNC a little more reliable in my opinion.

Eugene could use the same idea as his FindDrive but make it a FindServer.
He could test for his known directory on the server.

 

You can store UNC paths in a system variable just as easy as a drive letter. Its all text.

--
----
Ed
----
I was thinking in terms of having a list of server names to test against
instead of mapped drives.
Users can change their drive mappings but only IT can change server names.
New machines may not have any mapping but the servers will exist.
That makes UNC a little more reliable in my opinion.

Eugene could use the same idea as his FindDrive but make it a FindServer.
He could test for his known directory on the server.