Is the MDB file in your current version of Access? Did you design the application or is it an inherited file? Do you think a specific event caused the problem? Have you tried copying the whole file to another location on your drive?
I get the stupid error message 'The form name 'Buildings form' is mispelled or refers to a form that doesn't exist' for example when running a command that opens the form. But the form exists with that exact name....but just can't open or anything!
I can go into the VB editor on my 2000 machine but the code is only open forms stuff, and even when i try to edit or save i get the same problem that it doesn't recognise the name. I'm not sure about the secuity...i don't know much about this, but it says that the security is set so i can read and run etc..
1: Okay from the VBE use the search to find all references to the form you cannot open, and comment them out.
2: On the forms you cannot get to open go into the VBE behind each form and put a breakpoint on each forms on open event. (Even if you have to write some code to break on.)
3: Check the forms recordsource, and see if the queries are based on any missing tables. If they are you may be able to rebuild the missing table or locate the problem.
4: Once you have checked all the above you are ready to run the forms. As each form runs the breakpoints should enable you to step through the code and see any hidden items that also might be throwing you out.