Brian Thomas
asked on
Filesearch/filecopy and remote permissions
I am trying to first get a file directory and then to copy files from a computer on the network. To make a long story short, I am having problems doing this due to issues with permissions and security on the remote computer. Is there a way to get file directories and copy files from a remote computer but specifying access using a particular username and password other than that in use on the local computer? I know this can be and is done when opening remote ODBC data sources. Can it be done for simple file access?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check if that letter is not already used first.
ASKER
I'm going to accept Bobbit31's comment as the solution, though I had to do it a slightly different way. On our systems, the drive mappings are fairly densely populated already, and in a not always predictable fashion. So selecting a drive to map would be tricky. But a variation on this, a Shell("NET USE \\server\share /user:<username> <pwd>") allows pretty much the same thing as mapping, but doesn't require an actual drive letter assignment. Bobbit31 got me looking in this direction, so I'll award him the solution