Seem to have a file missing now

[border3]

Hi I am using A2000 on WINXP I platform plugged in a small amount of VB Code
to mark an old address as onsolete when a new one is added and it all worked
fine. A couple of days back I had my system hang unexpectedly and much
later I noticed that now when I call the VB code I get an "Error accessing
file. A Network connection may hgave been lost error message."
Everything looks ok though. Code is there and looks unchanged but when I
try to recompile I get the same erorr message. App is not shared across the
network. Anyone any ideas of what has gone wrong and what I can do to
fixit please.
--

 

[J. Goddard]

Hi

I had this exact same problem a couple of years ago, and below is the
response that John Vinson, MVP and lifesaver, posted to my newsgroup
query. By going to the MS knowledgebase article and following their
instructions, I was able to recover my database within a couple of hours.

But do check the version you have of the referenced .dll, and do upgrade
MS Access to SR 3 first - it is not painful at all (unless you have a
slow connection). This way you won't have to re-design your forms,
which definitely is a pain! You can't get away from the cut-and-paste
of the code, though.

Hope you are able to fix things up.

John



John Vinson's reply post:

This is a known and rather nasty bug. See

http://support.microsoft.com/?kbid=304548

Run, don't walk, to the Office update page and get Service Pack 3;
also, be CERTAIN to *immediately* compile any changes you make to VBA
code before closing the form or the database, and if you Import any
object containing code, immediately compile the project. Compacting
the database before compiling is especially prone to cause this.

Any database that shows this symptom is probably incurably damaged;
you'll want to import everything that can be saved (COMPILING
IMMEDIATELY after each import) into a new database, and recreate any
objects that don't import.