Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Course Of The Month
2 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS Access 2010 - Error 53-File Not Found
Posted on 2016-10-18
Hi Experts,
All of a sudden (I was working ok for about 3 hours and then when I switched a form I was working on from Design to View) I receive this error with a section of VBA Code displayed that has nothing to do with the form I was working on.
The Help associated with Error 53-File Not Found doesn't help.
I can Compact & Repair the .accdb but I can't compile into an .accde.
Can you please point me to where I might correct the problem? The code is about 98 Meg so not easy to supply. It also requires a specific Path setup to run.
Thanks,
Bob C.
All of a sudden (I was working ok for about 3 hours and then when I switched a form I was working on from Design to View) I receive this error with a section of VBA Code displayed that has nothing to do with the form I was working on.
The Help associated with Error 53-File Not Found doesn't help.
I can Compact & Repair the .accdb but I can't compile into an .accde.
Can you please point me to where I might correct the problem? The code is about 98 Meg so not easy to supply. It also requires a specific Path setup to run.
Thanks,
Bob C.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
12
11
3- +1
27 Comments
Active 2 days ago
Is it possible that anyone else (or a software utility) opened the database while you were working on it?
Active 2 days ago
Hi Joe,
If I click on a button on a form that I use as a menu to open the form I was working on, a Dialog Box opens with a Heading of: Microsoft Visual Basic For Application, a Message of 'File not found' and the options of OK and Help.
If I click OK a Visual Basic Window displays at the last point in the code that I had been in.
If I click on a button to open another form on the menu that form opens ok.
Therefore it appears to be directly related to the specific form I was working on.
Thanks,
Bob C.
If I click on a button on a form that I use as a menu to open the form I was working on, a Dialog Box opens with a Heading of: Microsoft Visual Basic For Application, a Message of 'File not found' and the options of OK and Help.
If I click OK a Visual Basic Window displays at the last point in the code that I had been in.
If I click on a button to open another form on the menu that form opens ok.
Therefore it appears to be directly related to the specific form I was working on.
Thanks,
Bob C.
Active 2 days ago
Hi Experts,
This is on a stand alone PC and I am the only one working in it.
Thanks,
Bob C.
This is on a stand alone PC and I am the only one working in it.
Thanks,
Bob C.
Active today
Open the VBA Editor >> Debug >> Compile.
Report back what happens ?
Should show where error is and what error is.
Report back what happens ?
Should show where error is and what error is.
Active 2 days ago
Hi Joe,
When I do this the message displays at whatever point I am in in the code. If it is the form I was working on it displays there. If I open the VBA Editor at an Event in another form, then close the VBA Editor and the form and then try to open the form that I was originally working on, the error displays and takes me to the last VBA Code that had been opened (not related to the form I was originally working on). i.e. It doesn't appear to be taking me to where the error exists.
Thanks,
Bob C.
When I do this the message displays at whatever point I am in in the code. If it is the form I was working on it displays there. If I open the VBA Editor at an Event in another form, then close the VBA Editor and the form and then try to open the form that I was originally working on, the error displays and takes me to the last VBA Code that had been opened (not related to the form I was originally working on). i.e. It doesn't appear to be taking me to where the error exists.
Thanks,
Bob C.
Active today
Well ... but with the VBA editor open ... in any Module/Procedure or a Form Module/Procedure .... you need to hit the Compile button ... so we can see what is up ...
Not really enough information to go on yet.
If nothing else, we can try Decompile ...
Not really enough information to go on yet.
If nothing else, we can try Decompile ...
Active 2 days ago
Hi Joe,
I can't think of how to get additional information.
How do I do a decompile?
Thanks,
Bob C.
I can't think of how to get additional information.
How do I do a decompile?
Thanks,
Bob C.
Active today
Well ...are you not able to Open the VBA Editor and from the Debug menu ... hit Compile ?
Because IF there is really a Compile error ... Decompile is not going to directly fix it.
Because IF there is really a Compile error ... Decompile is not going to directly fix it.
Active today
Meanwhile ... here is the Decompile procedure.
aaQicPostDecompile.txt
aaQicPostDecompile.txt
Active 2 days ago
Hi Joe,
I can open the VBA Editor and from the Debug menu click Compile at which point the Error message displays.
Thanks,
Bob C.
I can open the VBA Editor and from the Debug menu click Compile at which point the Error message displays.
Thanks,
Bob C.
Active today
OK ...
Where in the code - can you post that code?
It must be occurring on a specific line of code ?
Where in the code - can you post that code?
It must be occurring on a specific line of code ?
Active 2 days ago
Hi Joe,
I followed the steps verbatim in the Decompile Attachment.
When I got to Step 6B (From the VBA Editor...) after clicking the Debug > Compile option I get the File Not Found Error Message.
I then went on to Steps 7 & 8 but I still have the same problem exactly.
Thanks,
Bob C.
I followed the steps verbatim in the Decompile Attachment.
When I got to Step 6B (From the VBA Editor...) after clicking the Debug > Compile option I get the File Not Found Error Message.
I then went on to Steps 7 & 8 but I still have the same problem exactly.
Thanks,
Bob C.
Active today
Yep ... that's what I'm saying. Need to fix the compile error.
So ... need to see the code where the compile error is occurring.
Either post that section of the code, or upload a db wherein the error can be reproduced.
fyi ... I'll be offline for about 1.5 -2.0 hours starting now ...
So ... need to see the code where the compile error is occurring.
Either post that section of the code, or upload a db wherein the error can be reproduced.
fyi ... I'll be offline for about 1.5 -2.0 hours starting now ...
Active 2 days ago
Hi Joe,
It does not occur at a specific line of code. Goes to the last Event I had open. i.e. Not necessarily in the code for the form I was working on when I encountered the error.
If I last had open the code of the form I was working in, it opens there. If I open code for some other Form Event, close the Event and Form and try to open the form I was wos originally working on when I ran into the problem, it opens the code of the 'some other Form Event'.
Since it doesn't open where the error occurs I have no idea where to start looking for the source of the problem.
Thanks,
Bob C.
It does not occur at a specific line of code. Goes to the last Event I had open. i.e. Not necessarily in the code for the form I was working on when I encountered the error.
If I last had open the code of the form I was working in, it opens there. If I open code for some other Form Event, close the Event and Form and try to open the form I was wos originally working on when I ran into the problem, it opens the code of the 'some other Form Event'.
Since it doesn't open where the error occurs I have no idea where to start looking for the source of the problem.
Thanks,
Bob C.
Active today
I see.
First ... is there any 'file' that you can imagine that might be 'missing' ?
And you did do a Compact & Repair if I recall ?
Without the db ... it's very difficult to troubleshoot.
One other thing to check ... References.
Again, open the VBA Editor >> Tools >> References. Look for any listed as:
**MISSING <SomeReferenceName>
First ... is there any 'file' that you can imagine that might be 'missing' ?
And you did do a Compact & Repair if I recall ?
Without the db ... it's very difficult to troubleshoot.
One other thing to check ... References.
Again, open the VBA Editor >> Tools >> References. Look for any listed as:
**MISSING <SomeReferenceName>
Active 2 days ago
Hi Joe,
I did check the References and none of those I use are missing. I didn't check those I don't use since the list is very long.
Yes, I have tried Compact / Repairs numerous time throughout our discussions without success.
As a matter of course before I make too many changes I Compact & Repair / Compile and save the result as a backup in case I run into this type of problem.
I had made changes to one form and was in the process of this second form when I ran inot the problem.
I backed up my backup and using the backup copied the changes from the file with the problem. It compiles ok. So now I am just missing the latest change which was minor (adding a lable) and I'm up to date.
At this point I'm ok if you are to close this case with a solution of reverting to a bacvkup.
It would be nice to solve the problem but at this point I'm not optimistic..
Please let me know.
Thanks,
Bob C.
I did check the References and none of those I use are missing. I didn't check those I don't use since the list is very long.
Yes, I have tried Compact / Repairs numerous time throughout our discussions without success.
As a matter of course before I make too many changes I Compact & Repair / Compile and save the result as a backup in case I run into this type of problem.
I had made changes to one form and was in the process of this second form when I ran inot the problem.
I backed up my backup and using the backup copied the changes from the file with the problem. It compiles ok. So now I am just missing the latest change which was minor (adding a lable) and I'm up to date.
At this point I'm ok if you are to close this case with a solution of reverting to a bacvkup.
It would be nice to solve the problem but at this point I'm not optimistic..
Please let me know.
Thanks,
Bob C.
Active today
Well ... I always like to find the problem and solution ... that's how we learn.
But ... w/o seeing the db at this point, I'm pretty much out of ideas.
But ... w/o seeing the db at this point, I'm pretty much out of ideas.
Active 2 days ago
Hi Joe,
I too prefer to determine / understand a problem and them come up with a solution. I was a System Architect for Canada's' largest bank.
However sometimes after a considerable amount of effort it just isn't worth the trouble. I did note that the Help for the error indicated that it could be a dll problem with Visual Basic which probably meant that I would have to re-install it. Not my favourite option. Since going back one version and then duplicating the changes without any problems it appears a really odd ball cause.
So I'll do a little more coding tomorrow and if I don't run into the error again I will close this case.
Thanks for all your efforts.
Bob C.
I too prefer to determine / understand a problem and them come up with a solution. I was a System Architect for Canada's' largest bank.
However sometimes after a considerable amount of effort it just isn't worth the trouble. I did note that the Help for the error indicated that it could be a dll problem with Visual Basic which probably meant that I would have to re-install it. Not my favourite option. Since going back one version and then duplicating the changes without any problems it appears a really odd ball cause.
So I'll do a little more coding tomorrow and if I don't run into the error again I will close this case.
Thanks for all your efforts.
Bob C.
Active today
Bob,
<<I did check the References and none of those I use are missing. I didn't check those I don't use since the list is very long.>>
1. Check any un-checked reference (doesn't matter which).
2. Close the DB and Access.
3. Re-open and un-check the reference you just checked (it will be the last)
4. Now try a compile....still the same error?
Jim.
<<I did check the References and none of those I use are missing. I didn't check those I don't use since the list is very long.>>
1. Check any un-checked reference (doesn't matter which).
2. Close the DB and Access.
3. Re-open and un-check the reference you just checked (it will be the last)
4. Now try a compile....still the same error?
Jim.
Active 2 days ago
Hi Jim,
The result of trying your suggestion is as follows.
1. After checking a Reference I closed the Code Window. The Application Form I was originally on displayed with the Message.
2. I couldn't close the application (the Message stopped me).
3. Changed to Design View and closed the form.
4. Closed the application.
5. Opened the application and the Message displayed.
6. Opened the Code Window, accessed the Tools > References and deselected the last Reference.
7. Closed the Code Window and the Message displayed.
Jim,
I don't see how this can be a References issue when my immediately previous version of the application that I compiled was ok and still ok after making the changes between that version and the one with the problem that now compiles ok.
Thanks,
Bob C.
The result of trying your suggestion is as follows.
1. After checking a Reference I closed the Code Window. The Application Form I was originally on displayed with the Message.
2. I couldn't close the application (the Message stopped me).
3. Changed to Design View and closed the form.
4. Closed the application.
5. Opened the application and the Message displayed.
6. Opened the Code Window, accessed the Tools > References and deselected the last Reference.
7. Closed the Code Window and the Message displayed.
Jim,
I don't see how this can be a References issue when my immediately previous version of the application that I compiled was ok and still ok after making the changes between that version and the one with the problem that now compiles ok.
Thanks,
Bob C.
Active today
Was just covering the bases.
What it sounds like is that VBA project became corrupt. Usually where I see error 53 is when I unselect one or more of the objects in a save dialog right after I've created a new code module in some way (ie. one attached to a form). Access and VBA end up out of sync, and then you get error 53.
But just to cover the bases and based on the fact that you said you could not create a .accde, we brought up /decompile and references.
VBA carries two copies of the code; source and compiled. /decompile dumps all the compiled copies, which then forces a total recompile of everything. Generally this is what holds up creating a .accde. It's either that or references.
But on the references, sometimes they are not marked as missing or broken. The little procedure I gave you forces a refresh of the collection and either will then cause the error to be shown in the reference list, or will get rid of the problem (you can now create a .accde) if references were indeed the problem.
Sounds like in this case though it was actually missing some source code in the VBA project, which Access thought should be there.
Jim.
What it sounds like is that VBA project became corrupt. Usually where I see error 53 is when I unselect one or more of the objects in a save dialog right after I've created a new code module in some way (ie. one attached to a form). Access and VBA end up out of sync, and then you get error 53.
But just to cover the bases and based on the fact that you said you could not create a .accde, we brought up /decompile and references.
VBA carries two copies of the code; source and compiled. /decompile dumps all the compiled copies, which then forces a total recompile of everything. Generally this is what holds up creating a .accde. It's either that or references.
But on the references, sometimes they are not marked as missing or broken. The little procedure I gave you forces a refresh of the collection and either will then cause the error to be shown in the reference list, or will get rid of the problem (you can now create a .accde) if references were indeed the problem.
Sounds like in this case though it was actually missing some source code in the VBA project, which Access thought should be there.
Jim.
Active 2 days ago
Hi Jim,
Thanks for the information and insight into when these various conditions / errors may be created as well as the possible solutions to them.
I have done a lot of coding today on the form that I was working on when I encountered the error, without any problem.
I plan on closing this case latter today if all continues to go well.
Thanks,
Bob C.
Thanks for the information and insight into when these various conditions / errors may be created as well as the possible solutions to them.
I have done a lot of coding today on the form that I was working on when I encountered the error, without any problem.
I plan on closing this case latter today if all continues to go well.
Thanks,
Bob C.
Active 2 days ago
Hi Experts,
When we get to this situation its a little complicated as to what is the 'Best Solution'. I picked Joe's last entry since he put most of the work into this with assistance by Jim.
Thanks for all your effort.
Bob C.
When we get to this situation its a little complicated as to what is the 'Best Solution'. I picked Joe's last entry since he put most of the work into this with assistance by Jim.
Thanks for all your effort.
Bob C.
Featured Post
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses
Course of the Month2 days, 14 hours left to enroll
696 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.