Compact & repair

[Michelle]

I was in the middle of compacting & repairing my database
(saved on a floppy; I was transferring it from one
computer to another)when I got a disk out of room error.
Now when I try to compact and repair this database again I
get the message " Table TempMSysAccessObjects already
exists" and I can't complete the operation. Can someone
tell me how to get rid of this Table
TempMSysAccessObjects?
Thank you.

 

[Sandra Daigle]

Here's how to correct the problem:

Try deleting 'TempMSysAccessObjects'.

Open the database
Click Tools->Options->View
Check the box for View System Objects
Go to the database window and under tables, find and delete
TempMsysAccessObjects.
Compact the database (hopefully it will work now)
Go back to Tools->Options->View and uncheck the box for View System Objects

If this doesn't work you may need to import everything into a new database
file.

PRB: "Table 'TempMSysAccessObjects' Already Exists" Error Message May Occur
While Using the Compact and Repair Database Utility
http://support.microsoft.com/default.aspx?scid=KB;EN-US;818099