>>>Hello. Having trouble hard-coding drive assignments in visual foxpro for users on a network in Win95. To some users a shared network drive is one letter and to another user it's another. Is there a good way to reference "use t:Thisfile" as opposed to "use S:thisfile"?
>>>Thanks
>>
>>Each user may have own local configuration table which besides other things will store path to network data folder.
>
>so ahead of time, manual case by case basis must be evaluated for each user?


I'm dealing with the same problem. My solution (Not the best but it's mine and works with free tables) is to use a data dictionary. When the user needs to open a file, my generaic file open routine looks in the data dictionary and based upon the users network rights, the state of the app (Devopment or Production) and which way the wind is blowing, seeks the table name with the associated parameters and pulls the UNC path for the table. This allows me to move users to different data sets with the flip a a flag or two on the network.

Fred Lauckner
<< Standard Disclaimer Here>>