I have a VBA program I wrote in Access that uses an API call to find a persons Desktop directory. After that, it copies a shortcut off of the network drive and places it on the users desktop using the filecopy command.
These seems to work fine on everyones computer except for two users. They are getting a Run-Time Error 67: Too Many Files. Everyone in the company has different access to the network drives, but I figured if they didn't have access to that directory, it would give a path not found error, or something similar. When referring to the network drive I am using the form "\\Server\Dir\Dir\File" instead of a drive letter, since people have the same server mapped to different drive letters. If anyone can help me out, I would greatly appreciate it. Thanks.
Doug
These seems to work fine on everyones computer except for two users. They are getting a Run-Time Error 67: Too Many Files. Everyone in the company has different access to the network drives, but I figured if they didn't have access to that directory, it would give a path not found error, or something similar. When referring to the network drive I am using the form "\\Server\Dir\Dir\File" instead of a drive letter, since people have the same server mapped to different drive letters. If anyone can help me out, I would greatly appreciate it. Thanks.
Doug
