I have a small VB6 program built in an Excel environment running on XP Pro trying to write files into subfolder on a drive defined on a Windows Server 2003 server. I use a ScriptingFileSystem object.
When i write to the root of the drive it works fine. When I try to write to a subfolder I get “Runtime Error 70 – Access Denied.” I’ve researched file permissions, user groups, inheritance, DOS ATTRIB command, ad nauseum but still haven’t found a solution.
It would help if I knew how the programs appears to the security system – under my login ID, or what?
Thanks in advance for any information you can provide.