delete a temparory object - compact error

[Jessie]

Hi,
I inherited an Access database. It runs too slow
now. I tried to compact it, but always got a
message "Table 'TempMSysAccessObjects' already exists".

I can not find such an oject in the database table list.
I guess the compact process created a temparory object
called 'TempMSysAccessObjects'. I would extremely
appreciate if some one can point out how I can find that
object and delete it mannually or tell me what's going
wrong.
thanks a lot.
Jessie

 

[Tony Toews]

I inherited an Access database. It runs too slow
now. I tried to compact it, but always got a
message "Table 'TempMSysAccessObjects' already exists".

I can not find such an oject in the database table list.
I guess the compact process created a temparory object
called 'TempMSysAccessObjects'. I would extremely
appreciate if some one can point out how I can find that
object and delete it mannually or tell me what's going
wrong.

This can be a sign of corruption. Try importing all the objects into
a new MDB. Otherwise see the Access Corruption FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm