Compact & Repair Error

[Dave Titan]

Hi Folks,

I am getting the following error when trying to compact and repair a DB "Table 'TempMsysAccessObjects' already exists" This is using Office XP and it's happening on more than PC.

I've searched the tables and am unable to find this one?

Any ideas?

 

[KenHigg]

Have you tried turning the view sys objects option on, see if the table exists and then try to delete it?

???
kh

 

[ghudson]

Sounds like a corrupt system table. Create [open] a NEW database and import everything from that db into the new db.

 

[Dave Titan]

Ken,

Great stuff. Thanks for that, worked a charm.

Could you tell me if deleting hidden objects will have any adverse effects on a db?

Dave

 

[ghudson]

I would not recommed deleting or editing the system [MSys*] tables. They are hidden for good reason.

 

[KenHigg]

Normally I would never suggest even looking at these objects. It just seemed like maybe the system may have gotten part of the way through a rebuild routine and was interrupted for some unknown reason, leaving the temp table. So that next time the rebuild attempted to run, the sys could create it because it already existed...

Like I said, I would suggest hiding these again now that things are working...

kh

 

[Dave Titan]

I deleted TempMsysAccessObjects and the db is working away just fine. And with a compact and repair it's faster.

I've also hidden all the objects again.

I would say the DB may have been stopped halfway through something at somestage. It's weighing in at 30mb at the moment 50mb before the compact.