>>>I have a network drive mapped to a clustered server. The server name is "MyProdServer" and the mapping is like this:
>>>
>>>"Website on 'MyProdServer\S$' (P:)"
>>>
>>>I have tried unsuccessfully various ways to either SET DEFAULT or USE files in the directory under this. I get different errors regarding "device in use" or "permission denied" depending on which way I try. I have access to this server and the directory structure. I can see the files in Exploring and open them in other programs (Notepad, Excel), but not Foxpro. Any thoughts?
>>>
>>>
>>>USE "p:\data\Web_Mstr"
>>>SET DEFAULT TO "p:\data"
>>>SET DEFAULT TO "\\Pfgdsmebs00a\Website\data"
>>>SET DEFAULT TO "\\Pfgdsmebs00a\S$\Website\data"
>>>
>>Just a couple of SWAGs:
>>
>>- have you tried your commands above but without the quotes?
>>- is it possible your VFP temp files folder is set somewhere on S: or some other location where you don't have sufficient privileges?
>
>With and without quotes, and the temp folder is a local drive. Very strange, even if I issue SET DEFAULT TO ? and use the dialog, it will not let me go below the root directory.
Going even further into left field, VFP makes use of file- and record-locking features of file systems that typically aren't accessed when you're opening files with other programs like Notepad or Excel. If there are privilege issues with these locking features that might explain things. On the other hand, I wouldn't think a simple SET DEFAULT TO would require locking features.
Is it possible the server is somehow only letting certain registered applications access its files?
From your S$ syntax it appears the clustered server is Windows - is this actually the case? If so, which version?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up