Temporary Access Class Object in Project Browser

[Todd Lemen]

I have been reviewing a client's application, and found
an interesting anomoly... The VBA Project Explorer lists
an Access Class Object titled "Report_~TMPCLP573751".
There is no corresponding report object listed in the
database window (not even a hidden one). Hmm... How do
I get rid of this Class Object in VBA? the "Remove" item
is grayed out when I right-click on the Class Object in
the Project Explorer...
Thanks,
TL

 

[david epsom dot com dot au]

It looks like a deleted object. Compact and Repair:
if that doesn't help, decompile, using the /decompile
command line option for MSACCESS.EXE

(david)

 

[Todd Lemen]

Thank you for the suggestion. I've tried both, and still
have the "temporary" class object. I've tried both with
Access XP and Access 2003. Any other suggestions welcome.

TL

 

[david epsom dot com dot au]

I'm lost too. All I can suggest is to import all of the
(valid) objects into a new database.

(david)

 

[Todd Lemen]

Found a solution (thank you, Simon Liao of MS Tech
Support!). Here it is:
Delete all the code from the "temporary report" class
object. Recompile. Switch back to Access, where the
temporary report is displayed in design view. Display
report properties, select the "Other" tab, and set
the "Has Module" property to "No" (select Yes when
prompted about losing code). Close the temporary report,
selecting Yes when prompted about saving design change.
Voila, class oject module now removed from system...

TL