Ошибка file not found vba

I’m working on a big Access 2003 project with Microsoft Access 2007­. Recently, some users have started to experience problems with the buttons in my forms. For example, without any specific reason, clicking on a button or trying to execute any code will return the error:

File not found

There is no way to go into debug mode. When this happens the only thing to do is to restart the database. I tried adding the Stop command at the beginning of the executed block to try debugging it, but no code is executed at all. It’s like a compilation error but it’s only happening 5-10% of the time, which is really weird.

After some research, I found other people are having the same problem, for example this and this link. There are other examples too, with no real solutions yet.

My database can be okay for a week and then the problem starts to happen again. Half the time and users can’t do much; they need to restart the database once or twice to get it back working, and after a few minutes the error might happen again.

Because this is Access 2007 and there are a lot of people experiencing this bug, I can’t believe it isn’t more documented.

What’s the problem? Is the database somehow partially corrupted? What should I do? This is really annoying.

I had just experienced this for the first time. I had been making extensive coding changes in a form, and was required to reboot my PC without finishing debugging the code. When I opened the app, I immediately got the «file not found» message (it auto-starts a different form).

On a whim, I went to the form in question and commented out that entire module’s code and the problem went away. After I went back in and uncommented that code, everything still worked as normal. I was able to continue debugging that code and lived for the rest of the day happily.

answered Sep 25, 2015 at 17:21

A similar thing has just happened to me a couple of times with one of my .mdb front ends running in Access 2013, after the August 2019 update to Windows 10.

My DBs too have been through several versions of Access. On opening the database it says ‘File Not Found’ and throws up a public module (not one on which I have been working extensively recently), without opening the Autoexec (Switchboard) form. ‘Debug, Compile’ is possible and doesn’t suggest any problem.

For me too, typing one space (or blank line or other character) anywhere in the code, and then deleting it, and saving, closing and re-opening seemed to provide a workaround, and all has been well for the last few days (I am the only user at present).

There is no one obvious module involved, although I will probably suspect the form module I have been working on most recently if the problem persists in a troublesome way.

Now, a few days later I have de-compiled, compacted and re-compiled the database, halving its size, so maybe that will have done the trick. I hope so.

answered Aug 27, 2019 at 5:27

answered Sep 22, 2013 at 20:50

answered Mar 24, 2014 at 14:35

I had a problem similar to this. A blank «File Not Found» error.

I turned off AutoCorrect and after clicking through several prompts/warnings which had me concerned, I then reopened the database and the error went away.

When reopening the database the problem was resolved.

I suspect this will fix many «File not found» errors which are probably related to the temporary link table losing a reference for whatever reason.

answered Jul 23, 2014 at 22:41

I had this same issue MS Excel.

On the user pressing a button a useless File Not Found error appeared.

I ran through all suggested above and no change or help.

COMPLETELY ACCIDENTALLY I removed a module that i use for updating the Application status. This also has some array storage within. However, on removing this module (and commenting out references to it within my code) it appears that the issue is now fixed across users.

One Issue, is I have the same Module name within several different deployment’s of Excel Add-ins. I suspect that on first run Excel isn’t able to automatically assume the difference between them.

I had noticed a WORK AROUND for the error in which you create a break point on the first line of code for the button in question and then resume on break — I assume that this helped Excel evaluate and namespace the modules as to not cause conflicts.

answered Nov 26, 2014 at 11:43

answered Jan 12, 2015 at 15:21

Had the same problem. I stumbled on the fix by accident. For whatever reason, simply adding an on-click Event Procedure made everything better.

• Open the form in design mode
• Select an object on the form
• Press F4 to display the object’s properties
• 
• Event > On Click > dropdown > click [Event Procedure]
• Then click the three dots, which will create a new event, and launch the Visual Basic editor. This will also add default code into the Visual Basic editor
• Make no other changes
• Save and close changes to the form
• Restart the database

For what its worth, as I was wrestling with this issue, the error resolved itself in other ways, but none of them were repeatable.

answered Nov 7, 2017 at 20:29

answered May 5, 2018 at 21:01

I have had this problem for years in my access database. I tried all the above solutions an they all fixed the problem, only to have the problem reappear sometime later — always after VBA code change. I discovered that decompiling and then recompiling ALWAYS FIXES this problem, and is the quickest and easiest way to do so. So I have concluded that there is a bug in way Office only partly compiles after program changes like macros and VBA code changes. After a number of changes the system gets ‘unhinged’ and throws up the ‘file not found’ error. Reading thru the fixes users have found in this blog supports my theory. Nearly all these fixes would probably cause some sort and recompile the unhinged code.

MY SOLUTION

In summary I have found the following..

1. Doing a Decompile (without a recompile) will get rid of the error — but if the code is run on a different machine the error appears again.

2. Doing a decompile, then a recompile followed by a Compact and Repair results makes my app run on other machines with out any problems.

answered Mar 14, 2021 at 2:06

asked Nov 26, 2020 at 11:28

Thank you, terminal command line in William Lai’s answer worked! In case helpful for others, the only thing different for me was that 2 of the directories were appended with «.localized».

/Users/your-user-name/Library/Group Containers/UBF8T346G9.Office/User Content.**localized**/Startup.**localized**/Word

So far none of the above has worked for me. Worse, the dialog appears to come up on a hidden window, so I have to:

1. mouse to the Dock
2. locate Microsoft Word (small icon)
3. right click on the Microsoft Word
4. select Show all windows
5. navigate to the crude dialog (looks like something I saw in 1987)
6. click END
7. Repeat between 4 and 8 times for every document opened

answered Jun 20, 2022 at 22:22

Open Terminal and paste the following:

cd '~/Library/Group Containers/UBF8T346G9.Office/User Content/Startup/' && rm Word/linkCreation.dotm && rm PowerPoint/SaveAsAdobePDF.ppam && rm Excel/SaveAsAdobePDF.xlam && open '/Applications/Microsoft PowerPoint.app' '/Applications/Microsoft Excel.app' 

Hit enter, then in the windows that open (Excel and PowerPoint) click on the menu bar entry ‘Tools’, and in the drop-down, respectively ‘Excel Add-ins…’ and ‘PowerPoint add-ins…’. In each program, select the entry ‘Save as Adobe PDF’ and click on the - button. Click on OK.

answered Nov 14, 2022 at 9:51