Invalid Report_XYZ stuck in MS Visual Basic project window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an problem with a piece of code that was associated with a report that I have since deleted. When I open any form now I receive an error "Error accessing file. Network connection may have been lost." Clikcing OK pops the MS Visual Basic window. The window contains something titled "Report_NewFeature_qry subreport611" that no longer exists. How do I remove this object from the code base of my MS access DB file? I tried creating a dummy report but that didn't work.
 
rmbartis said:
I have an problem with a piece of code that was associated with a
report that I have since deleted. When I open any form now I receive
an error "Error accessing file. Network connection may have been
lost." Clikcing OK pops the MS Visual Basic window. The window
contains something titled "Report_NewFeature_qry subreport611" that
no longer exists. How do I remove this object from the code base of
my MS access DB file? I tried creating a dummy report but that didn't
work.
Click to expand...

Your problem may be different, but that particular message is associated
with a particularly nasty bug in Access 2000, which was corrected by
SP3. Check out this article to see if it applies:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

Office 2000 SP3 fixes the bug, but that won't repair your corrupted
database. I can suggest these options:

1. Revert to a backup.

2. Try opening the database via a command line specifying the /decompile
switch; e.g.,

msaccess.exe /decompile "C:\MyPath\MyDatabase.mdb"

3. Import all objects to a new database -- some objects probably won't
import, and you'll have to recreate them from scratch. When you do
import the objects, unless you've applied the service pack, it is
*crucial* that you compile and save the project before closing the
database.
 
Back
Top