kgittinger
asked on
Debugging help needed: Run-time error '70': Permission Denied
Can someone help me debug the attached. What I have for Command4_Click() works perfectly. I have just copied this and changed the import specification and table name for Command12_Click(). When I run Command12_Click(), I receive Run-time error '70': Permission Denied
RuntimeError.pdf
RuntimeError.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the grade. Good luck with your project. -Jim
btw I HIGHLY recommend you do this:
(1) In any code window go to Tools:References
(2) Set a reference to 'Microsoft Scripting Runtime', a.k.a. File System Object
(3) In whatever free time you have play with the .FileExists and .FolderExists methods, as these will enable you to screen what the users enter for files, to make sure they are legit.
btw I HIGHLY recommend you do this:
(1) In any code window go to Tools:References
(2) Set a reference to 'Microsoft Scripting Runtime', a.k.a. File System Object
(3) In whatever free time you have play with the .FileExists and .FolderExists methods, as these will enable you to screen what the users enter for files, to make sure they are legit.
ASKER