Report Error

  • Thread starter Thread starter AllenInGrocery
  • Start date Start date
A

AllenInGrocery

I have a report with code that suddenly won't open. I get
the following: "Error accessing file. Network Connection
may have been lost." The file is on my local machine. I
can access the code, the report design, but can't preview
it. I don't know what I may have done to cause this, but
can't seem to fix it. Any help would be greatly
appreciated.

Allen
 
Allen:

You are likely using Access 2000. The problem you are experiencing is a
known bug that occurs under certain circumstances (i.e. when a specific
version of vb6.dll is on your machine) when a db is closed when there are
uncompiled VBA modules within it Unfortunatly, there is absolutely no
work around to repair the report, other than possibly set its HasModule
property to false, save compile and compact the db, then go back and
recreate the module and functions. If that doesn't work, pull a back up
version of the database and delete the report in your current db, compile,
compact etc. and import the old version into the new db.
 
Back
Top