ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Access Error (https://www.excelbanter.com/excel-discussion-misc-queries/18513-access-error.html)

Greg B

Access Error
 
I have a problem when I leave the program I am writing for about 20 minutes
it comes up with the error : Path/File access error what is causing
this I can save it fine before the error and when the error comes up it
just freezes.

Thanks in advance

Greg



Dave Peterson

It sounds like you have a macro running in the background -- some type of OnTime
procedure. And the drive/path that its trying to write to isn't available (bad
code or a network/local drive that disappears???)

Next time this happens:
while in excel
hit alt-f11 (to get to the VBE)
hit ctrl-r (to see the project explorer)

Take note of all the workbooks/projects that are loaded.

If you don't recognize them, post back. But if you do recognize them (and some
of them look home grown), visit that developer and see if he/she can help.



Greg B wrote:

I have a problem when I leave the program I am writing for about 20 minutes
it comes up with the error : Path/File access error what is causing
this I can save it fine before the error and when the error comes up it
just freezes.

Thanks in advance

Greg


--

Dave Peterson


All times are GMT +1. The time now is 04:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com