Temporary Reports in VB Editor

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

Guest

I have 4 reports that I cannot see in the reports window of my Access XP
database. They are only visible in the VB Editor. I assume they are the
result of some sort of error as they are copies of legitimate reports but
their names are something like ~TMPCLP335501. The problem is that they are
causing the size of the database to increase significantly. Does anyone know
how to remove them? I have tried compact and repair with no success. I have
deleted all of the code behind them hoping to decrease the size of the
database which did not work either.

I would appreciate any assistance or ideas.

Thanks!

Tim
 
Tim,

This kind of thing happens sometimes, not just with reports but with other
object types as well. The solution is to compact the existing .mdb, then
create anew, blank .mdb, import all objects from the existing one, and
repeat any changes to the default settings you have made to the original
one. What you have now is a new, clean copy of the original database,
without the rubbish.
This done, you can change the name of the original .mdb (e.g. to
OriginalName-OLD.mdb) so you can keep it for a while just in case, and then
rename the new one to the original name.

HTH,
Nikos
 
Thank you, I will try this.

Nikos Yannacopoulos said:
Tim,

This kind of thing happens sometimes, not just with reports but with other
object types as well. The solution is to compact the existing .mdb, then
create anew, blank .mdb, import all objects from the existing one, and
repeat any changes to the default settings you have made to the original
one. What you have now is a new, clean copy of the original database,
without the rubbish.
This done, you can change the name of the original .mdb (e.g. to
OriginalName-OLD.mdb) so you can keep it for a while just in case, and then
rename the new one to the original name.

HTH,
Nikos
Click to expand...
 
Back
Top