Can't delete phantom Report Name A2000

  • Thread starter Thread starter Larry L
  • Start date Start date
L

Larry L

I Have a report that runs from a query which gets it's information from 5
other queries. All worked fine. I added one more query as a source for the
main query, and now it has slowed dramatically. I tried to copy the report
with a new name so I could try a couple of changes. It asked me for the
new name, and then went back to the reports screen, but the new report
wasn't there. Now in the Project explorer, the report is listed, but
clicking on it gives an "error accessing file " message. Compavting
doesn't help.

I actually tried copying the report again, with another name, same result!

How do I get rid of these 2 phantom files?

Thanks much,
Larry L
 
It sounds like you database is corrupted.

* _Firstly_, make a back-up of the database, even corrupted unless you
already have good back-ups of the database.

* Try the /Decompile switch. For more info, see MichKa's site:

http://www.trigeminal.com/usenet/usenet004.asp?1033

* Try also creating a blank database and importing all other objects to the
blank database. The Report may have been corrupted beyond repair but you
can try importing the Report to the new database.
 
Van,

I tried opening a new one and importing everything, and now I get an error
on every report I try to open that says "Error accessing file. Network
connection may have been lost." There is nothing on a network here, it is
all local.

So I decompiled it,and it gave me warnings about the 2 phantoms, cleared
it all up, and all seems to be fine! Thank you SO much for your time on a
Christmas eve. Merry Christmas!

Larry L
 
Well I spoke too soon. It appeared to be OK, but now gives me the same
errors. When I re-run the /decompile it gives me 2 warnings "An error
occurred while loading report xx" If I stop there, it says "The VBA
Project in the database is corrupt".

Any way around this?

Larry L
 
Hi Larry,

The error you reported, "Error accessing file. Network connection may have been lost" is a
very well known error. You need to download and install the latest service packs to
prevent this from happening again.

Start at: http://support.microsoft.com
Choose Search the Knowledge Base
Product: Access 2000
Search terms: Error accessing file. Network connection may have been lost

Search result:
ACC2000: Error Message: Error Accessing File. Network Connection May Have Been Lost.
http://support.microsoft.com/?id=304548

Tom
__________________________________________


Well I spoke too soon. It appeared to be OK, but now gives me the same
errors. When I re-run the /decompile it gives me 2 warnings "An error
occurred while loading report xx" If I stop there, it says "The VBA
Project in the database is corrupt".

Any way around this?

Larry L


__________________________________________
 
It looks like you need to import everything except the 2 Reports to the new
database and then re-create the Reports from scratch unless you have a good
backup.

Keep a number of back-ups & read the article suggested by Tom carefully.
You may have a major bug in your setup and this bug renders affected
databases unuseable.
 
Van,

I tried that 1st, and get the same error message. What confounds me is
that it was all working perfectly, and has been for some weeks, until I
tried to copy that report. It appeared to be working, then ended with no
errors, but also no new report listed. I can only see the report name in
the code window, and if I click on it, it gives me the "error accesssing
file".

Larry L
 
Back
Top