Error when trying to add Print event

  • Thread starter Thread starter Question Boy
  • Start date Start date
Q

Question Boy

I keep getting

'Error accessing file. Network connection may have been lost'

when I try to add an On Print event for the Detail section of a report.

There is no network connection to loose? It is a single mdb tables,
queries, forms, reports.. I performed a compact and repair, but no luck.
What is going on? I'm using Access 2000.

QB
 
Thank you for such a detailed answer!




Stephen Lebans said:
Here is a previous post from Sandra Daigle on this issue:

There is a known problem that causes this when you import or copy/paste
objects with a module and you close the mdb without first compiling the
code:

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.



--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
Click to expand...
 
Back
Top