Module Error Message

  • Thread starter Thread starter Brennan
  • Start date Start date
B

Brennan

Hello:

The past few days I have been getting the following error
message when I try to run reports that have some vba
modules in them.

Error Accessing file. Network Connection may have been
lost.

I have moved the entire database to a new access database
but I still get the message. When I try to re-create the
code, I can't even access the code page. (I'm trying to
add an event to the Detail Format Section) And when I try
to save the report, I can't even do that.

Any suggestions or comments would be appreciated

Brennan
 
Hi Brennan,

This is due to a known issue described in the following KB article:

ACC2000:Error Message: Error Accessing File. Network Connection May Have
Been Lost (Q304548)
http://support.microsoft.com/?kbid=304548

The corruption in your mdb cannot be repaired. You will need to use a recent
backup of the mdb. You may be able to import uncorrupted objects from the
damaged mdb into a new mdb and then import the corrupted objects from the
recent backup.

To *prevent* further corruption you should obtain the Office2000 Service
Pack. This issue has been resolved with this SP. For more information on
SP3 check out the following KB articles:

ACC2000: Issues Fixed in Access 2000 by Office 2000 Service Pack 3
Http://support.microsoft.com/?kbid=326605

OFF2000: Overview of Office 2000 Service Pack 3
http://support.microsoft.com/default.aspx?scid=kb;EN-US;326585


*** Note *** Until you install SP3 you should be sure to compile your
project after you import or copy/paste code into any mdb *before* you close
the mdb. This will also prevent further corruption.
 
Back
Top