Error! Cannot find file

  • Thread starter Thread starter Wendy Thomas
  • Start date Start date
W

Wendy Thomas

When I click on any buttons that i have put on my form, it
says that the file cannot be found. (Yes, I have already
applied the proper event procedure)

Also when I click any button in the tool box I get same
error:

"Error accessing file. Network connection may be lost"

I am not using a network.

And the application worked fine the last time I used it (2
days ago)

Should I try to reinstall Access 2000? ( I also use Access
XP - but not for this particular project)

Thanks in advance

Wendy
 
Did you import any thing from another database lately? If so, this is an
error that occurs frequently with Access 2000. There is a long work-a-round
in the Microsoft Knowledge base, which may be a daunting task. If you only
imported one form or report into your database this can be solved by
removing that last import from the database. However, make sure you have a
way to import that form or report again. Before you try to delete the
offending form or report; open the database by holding down the shift key.
This bypasses any startup operations that may be coded into the database.
Delete the form or report you imported. Immediately, compile the database
from the code editor window (See next paragraph for the How To).
If everything compiles fine and you don't get the network error then close
down the database and open as normal. Check to make sure everything is
working normal. If so, then import the form or report again. Make sure you
compile again immediately after importing. If you don't do this, the code
behind the form or report is what causes the Network error message. If that
does not work. Then do below.

The long way I found around this problem is to create a new database import
all the tables first. Then import the forms. If everything imports fine,
then enter the code editor window (yellow aqua/red icon on toolbar) and
issue a Compile against the database. If it compiles fine, then import the
reports; compiling after each import. Continue until all items from the
database are imported and recompiled. If every recompile works, then this
should solve the problem. If not, then it is something else.

If at anytime during the import you receive an error and the import process
quits; the last item or the next item is the culprit. In the case of a table
import error, the last table imported is most likely the culprit. If you
open it in the new database and the data is empty, then you know this is a
corrupted table. Delete this out of your new database; continue importing
the remaining tables. Do not try to import the 'bad' table.

In the case of a form, report, macro, module, then it would be the next item
after the last item imported.

If none of that works, then the Microsoft Way:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304548


Good Luck.
 
Thanks for the lengthy reply.

After much investigation and purely by mistake I found
that I had renamed a for to PlanPart which is a reserved
word in Access. Who would have thought? Anyway, I deleted
that form, remade it using a different name and all works
fine!

Wendy
 
Back
Top