[RESOLVED] Path File Access Error
I've got a pretty huge project in an Excel Workbook working very nicely, except for one extremely annoying issue...
Very randomly, sometimes while running code other times if I just leave the workbook open with nothing executing for a few hours, I will get a Path File Access Error. I end up having to hit OK about 45 times, then a
&H8000FFFF (-2147418133) Catastrophic Failure occurs ... crashing Excel and not being able to save anything..
Anyone know why this would occur? I thought I may have accidentally left a text document open or something of the such, but this error can occur if I simply open the workbook and execute no code (save the workbook_open where my initial form is loaded and displayed)...
Thanks much
Re: Path File Access Error
Also my workbook is saved on a network hard drive... but I've never had problems accessing/saving/etc files with it.
Re: Path File Access Error
Three Things that I can think of...
1) Have you checked the userform activate event?
Is there a code which is trying to access a particular path?
2) Have you checked the various events of workbook/userform wherein a code is trying to access a particular file/path?
3) Is there a piece of code somewhere which is trying to take a backup when idle somewhere which is not accessible?
Re: Path File Access Error
hmm.. everything seems to be checking out okay. I don't have any code set to run during idle times, at least that I'm aware of.
Only thing I can think of is that sometimes I don't unload forms, merely hiding them.. Is having a lot of hidden forms going to trip me up? or having a form hidden for a certain amount of time eventually crash Excel?
thanks
Re: Path File Access Error
Quote:
Originally Posted by pgag45
hmm.. everything seems to be checking out okay. I don't have any code set to run during idle times, at least that I'm aware of.
Only thing I can think of is that sometimes I don't unload forms, merely hiding them.. Is having a lot of hidden forms going to trip me up? or having a form hidden for a certain amount of time eventually crash Excel?
thanks
Well I don't think that hiding forms will hang excel (i could be wrong) there has to be some piece of code which is trying to access a particular path.
How big is your file?
Re: Path File Access Error
yeah and I still can't find it for the life for of me..
My file is currently at 92mb (Ouch I know, but the images are killing me).. Although the file does zip down to ~ 3.5 mb...
Would not closing a file I opened at one point hang me up?
Re: Path File Access Error
Quote:
Originally Posted by pgag45
yeah and I still can't find it for the life for of me..
My file is currently at 92mb (Ouch I know, but the images are killing me).. Although the file does zip down to ~ 3.5 mb...
Would not closing a file I opened at one point hang me up?
Till you reduce the file, I cannot even tell you to upload the file :lol:
Lets hope that after you reduce the file size (as mentioned in the other thread), we could have a look at your file... :)
Re: Path File Access Error
I would debug your workbook by commenting out all the code that may be accessing the file system. Save it and keep running. If no errors then uncomment some code and save. Repeat until you start getting crashes again. Then you will find the code, if any, that is making your workbook puke.
Re: Path File Access Error
Quote:
Also my workbook is saved on a network hard drive... but I've never had problems accessing/saving/etc files with it.
it maybe loosing connection to the network drive while the machine is idle, or some other occurrence
if you can, make a copy on a local drive to test if the problem still occurs
Re: Path File Access Error
Yeah I'm really starting to think it has to do with the network drive.. I'm going to begin working on the local drive and see if it occurs now
thanks for the help
Re: Path File Access Error
I'm going to declare this a success (hopefully don't jinx myself haha)... Moving the file onto a local drive seems to have fixed the problem... I think it may have been trying to autosave onto the network drive, which apparently wouldn't be available causing the crash.. anyway, thanks all for the help!