Link to home
Start Free TrialLog in
Avatar of kgittinger
kgittingerFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kgittinger

ASKER

Thank you very much
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.