Error message preventing database repair

[Rich]

Whenever I try to close my database or compact and repair
it I get the following error
message: "Table 'TempMSysAccessObjects' already
exists.'" I have no such table name. Does anyone know
what's going on here? Whatever it is, it appears to be
preventing me from compacting and repairing my database.

 

[Tom Wickerath]

Hi Rich,

This is probably caused by a corrupted system table. In any case, here is a Microsoft KB
article that explains how to deal with this situation:

http://support.microsoft.com/?id=818099

And here is how I found this information:
1. Start at http://support.microsoft.com
2. Select the Knowledge Base
3. Pick Access 2000 in the "Select a Microsoft Product" dropdown
4. Enter the search term: Table 'TempMSysAccessObjects' already exists

Result:
PRB: "Table 'TempMSysAccessObjects' Already Exists" Error Message May Occur While Using
the Compact and Repair Database Utility

The Knowledge Base at Microsoft is filled with LOTS of very useful information. You
should visit this site frequently when dealing with issues in any Microsoft software
product.

Tom
_______________________________________


Whenever I try to close my database or compact and repair
it I get the following error
message: "Table 'TempMSysAccessObjects' already
exists.'" I have no such table name. Does anyone know
what's going on here? Whatever it is, it appears to be
preventing me from compacting and repairing my database.

 

[Ling]

Hi,
This is a known thing from Microsoft. This link will show you the
Knowlege Base Article. If the link doesn't work, go to the Microsoft
website. It is article #818099, or just do a search on the table name
"TempMSysAccessObjects" on the site to bring it up.

I found Method 1 to work, but it's not permanent, and will continue to
happen intermittently if you just delete this system table. Method 2
is probably the better solution, but I didn't bother to try it.

Just another Access "bug" of some sort...

Ling663

 

[Ling]

DUHHHH
here's the link

http://support.microsoft.com/default.aspx?scid=kb;en-us;818099

oops sorry!