How to delete ghost report

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

When viewing object dependencies of a query, it includes a report with a
file name ~TMPCLP149401. When I click on it's link in object dependencies
it's a real report that can be edited, printed etc. I can even overwrite it
by saving another report to that file name (after getting the "file already
exists" warning.) It just doesn't show up on the list so I can't delete it
or rename it. Compact-and-repair doesn't get rid of it. Moving the ~50
tables/forms/reports/queries to a new mdb one at a time (the only way I
know) would be a huuuge job Maybe I'm just being retentive, but the idea
of ghost wandering my .mdb seems like it could make trouble. Is there a
way to get rid of it?

Thanks!
 
Fred,

Let's not move those one at a time...

Create a new database, import all the objects you want from the old
database. That ~TMP file might be the beginning of something bad, like
corruption, so might be a good idea to move everything anyway.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm
 
Gina,

Thanks twice over! Solved the problem and also your comment made me fish
around and learn a way to move the objects other than one at a time.
 
Back
Top