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.
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.
