Rcvd err msg: File Not Found

[Dennis]

When I open my development database, I receive the error message in a message
box:

Window Title: Microsoft Visual Basic

Message File not found:

Buttons: Ok Help


That is all it says. It does not tell me which file was not found.


The VBA code window opens, but there is no highlighted line. The VBA code
Window has [break] in the title bar.

I hit Run / Reset and the Main Menu / switch form appears. The main menu
form is specified in the StartUp / Display Form/Page option. The main menu
is a actual form.

I've not changed this code in months. I reloaded it from a previous backup
that was 3 days old and everthing is working fine.

Also, I just upgraded to Windows 7 from XP. I did notice that the paths
within Access for all of the images in my forms still point to C:\Documents
and Settings\Dennis\My Documents\Access Images. Unfortunately, on Windows 7
those images are stored in C:\Users\Dennis\Documents\Access Images.


Is this a sign that my database is about to crash or is this just an Access
feature?


Dennis

 

[Dennis]

How large is your database? Are the tables in a separate backend or in the
file with the application code and forms?

(The "other Dennis" - heh)

 

[Daryl S]

Dennis -

Yes, if the files are now in a different place, then the code that looks for
them in the old place will come up with "File not found". Look through your
code and any macros for the old file paths and change them to the new path.
Remember that depending on your error handling, the error may have happened
in a module other than the one with the error message.

 

[Dennis]

Other Dennis


Q. How large is your database?
A. Small - this is my development database - 500 rcds in the big table.



Q. Are the tables in a separate backend or in the file with the application
code and forms?
A. Tables are in a separate backend.



This Dennis

 

[Dennis]

Dary,

I've changed the database path and the linked tables, so all of that is good.

Q. Yes, if the files are now in a different place, then the code that looks
for them in the old place will come up with "File not found".
A. I would have though this. However,two things contradict this idea.
1. When I moved the code to Windows 7, I did not make any changes to
the image paths. Everything worked fine.
2. The way I fixed the problem is I imported the old code for my
startup program from a 3 day old backup. Once I did that, the problem went
away. I strongly believe the problem was in the startup program.


Q. Look through your code and any macros for the old file paths and change
them to the new path.
A. I do not have any macros. I write iin VBA. I've yet to spend the time
to learn macros.


Q. Remember that depending on your error handling, the error may have
happened in a module other than the one with the error message.
A. Yes, I've learned this the hard way. So now I'm very careful.


But like I said, the problem went away as soon as I reloaded my startup
program. I did not make any changes to the re-loaded version and I've not
made any changes to the startup program in months.

Thanks,

Dennis