Consulting

Results 1 to 8 of 8

Thread: why do i get path/file access error always?

  1. #1
    VBAX Regular
    Joined
    Sep 2010
    Posts
    40
    Location

    why do i get path/file access error always?

    gudday everyone

    like my title says, i got a problem with this "error path/file acces error" always when i leave my project for sometime(shortest about 30sec) or when im in the middle of coding, then another problem occurs after that which makes me not save my progress and then excel errors afterwhich it restarts. though it reserves an autosave still its bugging me crazy..

    what will i do?
    thanks

  2. #2
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,998
    Location
    We will need far more detail.

    System type, version of Excel, what you are working on before the break/pause, is it always in the same file/workbook, etc. Remember we are not there working with you, so need to give us as much detail as possible.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    VBAX Regular
    Joined
    Sep 2010
    Posts
    40
    Location
    aha ok. i thought its a common error.

    here are the details

    well im using xp xp3, ms excel 2007,
    it was the same project where it happens always.
    error occurs while im writing a long macro or when im testing a macro or just pause for break/surf net.

    if theres still lacking, ill be glad to give more details.
    -it happens again T_T

  4. #4
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Check your options for valid backup folder. However, since it recovers, I doubt that is it. Another problem might be links that don't point to a valid location though this does not result in such a problem usually either.

  5. #5
    VBAX Regular
    Joined
    Sep 2010
    Posts
    40
    Location
    Quote Originally Posted by Kenneth Hobs
    Check your options for valid backup folder. However, since it recovers, I doubt that is it. Another problem might be links that don't point to a valid location though this does not result in such a problem usually either.
    yes i thought about that, if its the link that causes problems runtime error should occur and then it auto debugs showing the line that causes it, not this path/access error.

    im afraid that if i finish this project, this error may occur upon user usage..T_T
    i want to understand why this error occurs and how to manage,kill it...
    hoping for some answers...

  6. #6
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Without seeing the workbook, it is near impossible to troubleshoot. Look for an OnTime() line of code or your sheets and workbook code objects.

  7. #7
    VBAX Regular
    Joined
    Sep 2010
    Posts
    40
    Location
    sir kenneth,
    ill email you a copy after i finished it, maybe in a week.
    or do you want an unfinished one?
    i have no OnTime() syntax on my code? or is it built in/on hide?
    thanks
    ..........................
    another thing
    "error path/file access error" when occuring, hides the properties of the actual userform on design time / you cannot access the userform.

  8. #8
    VBAX Regular
    Joined
    Sep 2010
    Posts
    40
    Location
    i guess im not the only one experiencing/had have this error.
    i googled again and the same problems accounted on the other forums/sites, still theres no clear answer on none of them except maybe decreasing the chances upon moving the file to a local drive, or the drive where excel naturally saves the file(MY DOCUMENTS).


    well if anyone had have this problem,hoping you post some solutions please...
    thanks in advance

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •